Forum Discussion
Excel Formula Help for $0.00 Value
I am in need of help with a formula again. This time it is for Conditional Formatting (at least I think). So I've tried every method I can think of, as well as using Google, to get cell D5 to show ...
In the desktop version of Excel, you can hide all zero values in the worksheet:
- Select File > Options.
- Select Advanced.
- Scroll down to the section 'Display options for this worksheet'.
- Clear the check box 'Show a zero in cells that have a zero value'.
- Click OK.
If you don't want that, you have several alternative options:
- Change the formula to =IF(Calculations!B96+Calculations!C96=0,"",Calculations!B96+Calculations!C96)
- Or set the number format of the cell with the formula to the custom format $0.00;-$0.00;