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"
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