Hi Dick

yep, send it to me as this doesn't make much sense (julied_ng at hcts dot
net dot au)

Regards
JulieD

"Dick" wrote in message
...
Julie I know how to use it but I don't get numbers there only TRUE or
False
Maybe I can send you the spreadsheet and you can try it yourself
Dick

"JulieD" wrote:

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