Ignore "ZERO" in a Cell

[jaxs2009]

Running Excel 2016 I have this formula in cell G8 which is working,

=IF(F8="","",ABS(D8*(1-F8)-D8))

Cell F8 is percentage/% formatted
Cell D8 is accounting formatted with a entered/fix $ value

With this formula is there any way for cell G8 to ignore zero?

Thank you for all who respond.

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[Joe4]

That are a variety away to "hide" zeroes.
See here: https://support.office.com/en-us/ar...o-values-3ec7a433-46b8-4516-8085-a00e9e476b03

 

[jaxs2009]

Man, how simple, I just can figure out why I didn't think to check options let alone advanced options. I guess my brain was stuck on the formula itself.

Thank you.