Dick

Paste the formula you have

IF uses the syntax

=IF(Test,Do_This_If_True,Else_Do_This)

Do you have all three arguments?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dick" wrote in message
...
I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance