Similar to IFERROR but looking for ) value, not error

[RodneyW]

If I use this formula =T6/I6 and the cell has no value, it displays the #DIV/0!. I prefer the cell to be blank as opposed to showing the error. That's resolved with this formula: =IFERROR(T6/I6,"")

Similarly, I'm using this formula: =H6-I6-R6 and if the value is 0 I want it to appear blank. I can resolve this by using conditional formatting to set the font to the color of the background if the value is 0 but is there a way to do it with a formula?

Thanks in advance

 

[Joe4]

One way:

=IF(H6-I6-R6=0,"",H6-I6-R6)

 

[RodneyW]

One way:

=IF(H6-I6-R6=0,"",H6-I6-R6)

Thanks

 

[Joe4]

You are welcome.
Glad I was able to help!