Forum Discussion

Copper Contributor

Jan 11, 2018

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

Formulas & Functions

Need Help

Damien_Rosario
Jan 11, 2018
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

Damien_Rosario

Silver Contributor

Jan 11, 2018

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

David Doddridge
Copper Contributor
Jan 11, 2018
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
- Damien_Rosario
  Silver Contributor
  Jan 11, 2018
  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
  if formula example.xlsx21 KB
  - David Doddridge
    Copper Contributor
    Jan 11, 2018
    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