> < = arguments

I'm really confused, and the in-built Excel guide did not help.

Even the simplier formula containing those operators ( > < = ) is considered WRONG by my Excel.

What's wrong for example in this:

=IF(A1>A2;B1;C1)

Whatever i write where A2 is (be it a number or a cell containing a number)
i get an error message which highlights "A2".
Note that I get the same error even if I paste a similar function from the help guide! And note that A1 and A2, in this example, are both cells containing number and labelled as "number".

Help

commas not semi colons

try this

=IF(A1>A2,B1,C1)

this should work as im pretty sure u cant use ( ; ) that sign

Simple and correct! Thank you very much.

That solved my problem, but told me that Excel guide contains errors... I'll buy a manual

Originally Posted by Stuie

try this

=IF(A1>A2,B1,C1)

this should work as im pretty sure u cant use ( ; ) that sign

I don't have a problem within the Sheet, It's creating the date in a sub routine using txtDay, txtMonth,txtYear. The DateSerial won't accept them, It's looking for numeric values, not text