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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top