--
Life isa journey not a destination

Suppose I want to test if the value in A1 is greater than 10
=IF(A10,"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
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Sherees" wrote in message
...

--
Life isa journey not a destination

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


"Sherees" wrote:


--
Life isa journey not a destination