Error Display window "There's a problem with this formula"

Question

I have a simple formula that I have been usuing for years. Actaully, worked until a couple of days ago.  =round((a2/0.25),0)*0.25

This is used to round our retail price to the nearest quarter. When I tried to execute this formula now, I get an error window.

There's a problem with this formula.

Not trying to type a forumal?

When the first charcter is an equal(=) or minus (-) sign, Excel thinks it's a formula.

you type: =1=1, cell shows : 2

To get around this, type an apostrphe (') firts:

you type: '=1=1, cell shows: =1+1

Anybody know why this just started or how tosolve it? Any help would be greatly appreciated.

Thank you

Russ

Answer 1

Hi, not sure what you want to accomplish the problem is the comma you have after you close the first parenthesis remove it and works,

=((A2/0.25))*0.25

Answer 2

Thanks for the response. To clarify the situation further, the formula is not the problem. It works fine on any other pc that I work on. The problem is any time I enter this formula or try an IF formula  ,  the error window pops up and I can't get by it. This only happening on my main pc.

Answer 3

Thanks for the response. To clarify the situation further, the formula is not the problem. It works fine on any other pc that I work on. The problem is any time I enter this formula or try an IF formula  ,  the error window pops up and I can't get by it. This only happening on my main pc.

Hi Russ0950.

After 6 hours of looking videos on the internet, tutorials, help on excel 2013, 2016. I found a solution. I almost went crazy. You wont believe how stupid is design EXCEL 2016. I dont know if on 2013 happen the same problem. 

Here is the solution.

My Windows 10 and Excel 2016 are in English, but my regional setting are for Spanish (Venezuela), so my keyboard layout and regional setting are different than English. So after looking all the help on English, and tutorials, and so on, I realize that the formulas in EXCEL are in ENGLISH but the format and symbols use on the same formulas must be used on the setting from my WINDOWS. (For my thinking that's totally stupid. If you look on the HELP of EXCEL on English the examples didn't work because the use different symbols. Example on the TEXT formula they use a comma separator ( , ) on the examples and after spending ours of research i realize that it has to use the symbol ; that is used on the Spanish EXCEL even do my EXCEL is on English. Totally stupid. Not even that the same was for the format option for DATE like DD/MM/YY on Spanish EXCEL for YEARS use AA not YY.

So for making the explanation for your problem short here is your formula changed so you can used it.

=ROUND((A2/0,25);0)*25

If you see i change the 0.25 to 0,25 because on Spanish regional setting (my setting) the English didn't work. And before the 0 you use the symbol , and it has to be ; so there you are totally stupid is a formula used symbols it would be great to use the same symbols. So if you change your windows regional setting you don't need to spent hours of research and not try to learn all different ways of syntax.

So I hope these helps you.

Cheers and good luck.

Answer 4

His error had nothing to do with Spanish. He said he has been using the same forula for years and now gets this error. I am also having the same issue and no matter what I do, the error dialog box keeps coming up. Even just took the advice and typed an apostrophe for once. Still nothing. Tried searching the web for solutions and I have even searched for this all throughout an excel 2016 (book) But nothing is mentioned about it anywhere. Thanks Microsoft inc. 2013 never had this problem. Will someone please quit playing games and just answer the question instead! Why would a formula suddenly quit working! Clearly was released before testing!