Forum Discussion
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 less than 0 then I would like cell C10 to say "UNDER" and if cell B10 is equal to 0 then I would like cell C10 to say "NO CHANGE"
I know this is pretty basic for a lot of you and I thank you in advance for your time in helping me solve this problem.
Regards, Dave
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
7 Replies
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
Hi Damien, thank you for your efforts:
Did you screenshot that from your computer? I copied and pasted into mine and each result simply said "OVER"
Ciao, Dave
Hi David
Here's the file I had created that you saw in the screen shot.
See if this helps?
Also here's a screen grab of the formula!
Cheers
Damien
I don't remember exactly, but you should search on youtube something related to the IF formula together with AND.
Good luckThank you will do.
Have a good weekend
Tony
