Formula - If Statement with blank

  • Thread starter Thread starter C Kreig
  • Start date Start date
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.
 
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
 
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.
 
Back
Top