What is the if formula?

  • Thread starter Thread starter Sherees
  • Start date Start date
Suppose I want to test if the value in A1 is greater than 10
=IF(A1>0,"It is greater than 10", "Not greater than 10")

The syntax (rule) is
=IF( test, what_you_want_if_test_is_TRUE, what_you_want_if_test_is_FALSE)

Experiment a little and you will soon catch on
best wishes
 
Slightly, a different approach.
If you must handle more than 2-3 values - I would suggest to type them into
adjacent cells and to use a much "shorter/simpler" formula.
To my opinion, it is much easier to treat arguments/values outside the
formula.
http://img696.imageshack.us/img696/792/noname.png
Micky
 
Back
Top