Forum Discussion
Excel formula question
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
Hi Damien:
That worked! Thanks! I realized when I first copied and pasted your formula that I forgot to change it to reflect the appropriate cell locations in the spreadsheet I was using....duh!
Thank you so much for your help!
Enjoy the rest of your day, Dave
- Hi Dave
Glad to hear it!
Can you please mark the answer as your best response, so that other users know that it is the solution?
All the best pal.
Cheers
Damien