Nick I have all the arguments correct but for the life of me I don't get the
values only TRUE or FALSE
Maybe I can send you the spreadsheet and see what you come up with


"Nick Hodge" wrote:

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