Question Locked

Excel conditional formula

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to add a condition to my formula. I would like only a + or - value to display. If zero, I would like to cell to display a blank

3 replies

by rdk55

This should work...

=if(a1=0,"",a1)

by nodisalsi

=IF($CELL=0," ", IF($CELL<0,"-","+"))

change $CELL to whatever the cell reference you are using.

This discussion is closed to new replies.