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

What you are looking for is commonly known as a Nested IF. The 2nd IF acts as the

value_if_falseargument 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 OkWhat happens if "Q"

equals2?

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

Ask Your Question

Weekly Poll