I have a formula that works for what I need it to but in the cell when it should be a 0 value, it shows FALSE.
=IF(D18>0,(E18/SUM(E9:E18))*C8)
Is there an easy way to adjust the formula to show a 0 value instead of a FALSE in the cell?
I have a formula that works for what I need it to but in the cell when it should be a 0 value, it shows FALSE.
=IF(D18>0,(E18/SUM(E9:E18))*C8)
Is there an easy way to adjust the formula to show a 0 value instead of a FALSE in the cell?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks