Forum Discussion
TROUBLES WITH EXCEL IF FORMULAS
When I try to use IF formula, excel show pop-up window: There is a problem with formula.
4 Replies
You don't provide any details, so it's impossible to know what causes the problem.
One possible issue: if you use point as decimal separator, use commas to separate the arguments of the function:
=IF(A1>37, "Yes", "No")
But if you use comma as decimal separator, you should use semicolons to separate the arguments:
=IF(A1>37; "Yes"; "No")
Dear Hans Vogelaar.
I don't have any decimal separators, since tha field format is time: ( 00:00:00 )
Kind regards.
How do you write two-and-a-half? As 2.5 (point is decimal separator) or as 2,5 (comma is decimal separator)?
