Formula - If Statement with blank

C

C Kreig

Below is my current formula:
=IF(SUM('Global KPI Monitoring chart'!D7:D8)=0,NA(),SUM('Global KPI
Monitoring chart'!D7:D8))

What I need to do is if the cell blank I would like it not to show a value.
If there is a Zero in the cell I would like it to display the zero as the
value.

Thank you in advance for your assistance.
 
J

Jacob Skaria

Try

=IF(SUM('Global KPI Monitoring chart'!D7:D8)=0,
IF(AND('Global KPI Monitoring chart'!D7="",
'Global KPI Monitoring chart'!D8=""),"",0),SUM('Global KPI Monitoring
chart'!D7:D8))

If this post helps click Yes
 
J

Jacob Skaria

Are you sure..Copy paste the below formula ...

=IF(SUM('Global KPI Monitoring chart'!D7:D8)=0,
IF(AND('Global KPI Monitoring chart'!D7="",
'Global KPI Monitoring chart'!D8=""),"",0),
SUM('Global KPI Monitoring chart'!D7:D8))


If this post helps click Yes
 
D

David Biddulph

I would suggest that you recheck the formula, as it should not be able to
return TRUE. Did you try to retype it? If so, you probably typed it
incorrectly so go back to Jacob's message, copy the formula, and paste into
your formula bar.

If in doubt, copy your formula and paste it back here so that it can be
checked.
 
Top