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

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.

In case you are still searching for an answer--

Check your system's regional settings to see what your "List Separator" is set to:

In Control Panel, search for Region then select Change date, time, or number formats, click the Additional settings... button, then look for List separator under the Numbers tab.  In my case, I had it set to a pipe '|' because I was messing with some script that would change an XLS to a CSV and needed to end up with a pipe-separated file instead of a comma-separated one.

Either use that character to separate the values in your formulas (in my case, =VLOOKUP(A1,A2:B2,etc would need to be =VLOOKUP(A1|A2:B2|etc ), or if you don't need it to be anything other than a comma, change your system's list separator back to a comma.

Please check the advanced setting in Excel. Keep the "Use system separators" checked ( ticked ).

Recently I unchecked this setting. After this ; is taken in place of ,

After reverting the setting back, formulas worked fine.

This setting might be changed purposely or automatically.

In case you are still searching for an answer--

Check your system's regional settings to see what your "List Separator" is set to:

In Control Panel, search for Region then select Change date, time, or number formats, click the Additional settings... button, then look for List separator under the Numbers tab.  In my case, I had it set to a pipe '|' because I was messing with some script that would change an XLS to a CSV and needed to end up with a pipe-separated file instead of a comma-separated one.

Either use that character to separate the values in your formulas (in my case, =VLOOKUP(A1,A2:B2,etc would need to be =VLOOKUP(A1|A2:B2|etc ), or if you don't need it to be anything other than a comma, change your system's list separator back to a comma.

This is the solution that works for me. A simple changing of List Separator from ";" to "," did it. Thanks a lot.

Hello,

In your formula =round((a2/0.25),0)*0.25    replace the  ,  with  ;