Here is an example: =IF(A10;"100"). Of which comes up as FALSE as a test which should be correct. Look in the help section of excel, it includes a good reference.

I think your formula should look like this:

=IF(I3;"1 "). I hope this helps you.

I'm surprised that it works like that on any user's PC: Excel requires separators between the function's 'arguments' (i.e., those things telling it what to test and the 'what to do if it is true', 'what to do if it is false').

The proper separator is a comma, so your function should read: IF(I3>1,"YES","NO")

which WILL work on any user's computer with any version of Excel.

It appears that you are missing commas in the formula. Please try this:

=IF(I3>1,"YES","NO")

## IF function in Excel 2003 error

Simple example of this error is:

=IF(I3>1 "YES" "NO") where I3 is above 1. the standard error message comes up. Do I need to re-install Excel as as the formula works on other users PCs