=if() function is not working like it should be

[PhilipeC]

Any formula that starts with =if() doesnt work. What should i do?

 

[iliace]

Any formula that starts with =if() doesnt work. What should i do?

What do you mean by "doesn't work"? Is it showing the text of the function instead of the desired calculation? Or is the calculation wrong?

In the first case, you should check to see if you cell is formatted as Text. If so, you will need to change the cell format to something else, and re-enter all the formulas.

If the calculation is wrong, however, you should post a sample of your data, the calculation you are using, and what is the discrepancy between the result it is producing vs what you expect.

 

[PhilipeC]

Its a simple formula =IF(G1="","",G1-10) and it doesnt work, shows this message ´the formula you typed contained an error´ just for testing i tried this formula on the excel online version and it did work. Any formula that starts with =IF doesnt work.

 

[PhilipeC]

I forget to mention the cell is not formatted as text.

 

[jtakw]

Hi,

Is it possible that your region uses ; rather than , ???

If so, try:

=IF(G1="";"";G1-10)

Also, don't forget the other formula I suggested, just in case, there are Text in column G: https://www.mrexcel.com/forum/excel-questions/1054007-subtract-number-left-column.html

 

[PhilipeC]

Its working now i tried the formula with ;
What a headache for such an easy solution. Thankyou

 

[jtakw]

You're welcome, welcome to the forum.