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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro is not working properly 5
If Formula for displaying a message 7
Longer Days 6
Feckit's Photo Thread. 12
Media Player Classic - Home Cinema, Closing Down. 4
Skynet --- ooopps sorry read -- Starlink satelites launched today. 2
Bargain EPIC Store Spring Sale 2020 - inc. GTA V Free 6
WF-2540 printer cartridges; (tiny!): Refill? Reset? 4

Back
Top