Forum Discussion
Solved
Excel formula question
I am having trouble writing a formula to solve the following:
In cell B10 (for example) if the value is greater than 0 then I would like cell C10 (for example) to say "OVER", if cell B10 is les...
Hi David
Using Cell B10 as the example source cell, try this formula:
=IF(B10=0,"NO CHANGE",IF(B10<0,"UNDER","OVER"))
Basically, the first condition checks if the cell is =0, the next one checks if it's under 0 then say UNDER and if it's over 0 say OVER.
Hope that helps!
Cheers
Damien
I don't remember exactly, but you should search on youtube something related to the IF formula together with AND.
Good luck
Thank you will do.
Have a good weekend
Tony