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