Double sets of formula

Microsoft Excel 2003 (full product)
September 14, 2011 at 02:22:16
Specs: Windows XP
Hi guys,

Shame, I used to be able to run rings around excel, seem to have forgotten it all now.

Basically, I am making a spreadsheet displaying, in weight, how much grease is going to a bearing of a machine.

Now in Column "Q", I have the weight (if been tested). Of how much grease is in that bearing.

And in Column "U", I have the status of that bearing dependant on what is in column Q.

Now, i have worked out how to make it so that if there is no information in any of the cells of Column "q", the value of any cell in Column "U" is "Needs Checking".

But i also would like it to be, if a value of any cell in column "q" is Lower that 2, i want the appropriate cell in "U" to be WARNING.

I tried doing this formula in Column "U"
=If(Q6=0,"needs checking","ok")=If(Q6<2,"WARNING","OK")

This just seems to make it so the value of "U" is either True or False.

So to sum up

If cell in "Q" is Blank, then U says Needs checking
If cell In "Q" is lower then 2, then U says WARNING
If cell in "Q" is Greater then 2, then U says Ok


See More: Double sets of formula

Report •


#1
September 14, 2011 at 05:16:03
What you are looking for is commonly known as a Nested IF.

The 2nd IF acts as the value_if_false argument for the 1st IF.

=IF(Q6=0,"needs checking",IF(Q6<2,"WARNING","OK"))

While this formula will meet the criteria you posted, there may be an issue.

You said:

If cell In "Q" is lower then 2, then U says WARNING
If cell in "Q" is Greater then 2, then U says Ok

What happens if "Q" equals 2?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question