What is the if formula?
-- Life isa journey not a destination |
What is the if formula?
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 |
What is the if formula?
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 |
All times are GMT +1. The time now is 07:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com