Hi Dick
here's some examples of how to use the IF function
=IF(A110,A1,B1)
displays the values in the cell references
=IF(A110,2,5)
displays the values 2 (if true) or 5 (if false)
=IF(A110,A1*1.1,A1*1.05)
if true, displays the value of A1 plus 10%, if false displays the value of
A1 plus 5%
=IF(A110,"Good","Bad")
returns the text values Good or Bad.
=IF(A110,IF(A120,"Very Good","Good"),IF(A15,"Bad","Shocking"))
nested IF to return the values of Very Good (if over 20), Good (if over 10),
Bad (if over 5) and Shocking if 5 or under.
Hope this gives you a bit of an idea of the different ways an IF function
can be used.
Regards
julieD
"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
|