Formula - If Statement with blank
 

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.

Formula - If Statement with blank
 

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
---------------
Jacob Skaria


"C Kreig" wrote:

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.

Formula - If Statement with blank
 

Good morning Jacob-
When I use that formula it put the word true in the value.

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"C Kreig" wrote:

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.

Formula - If Statement with blank
 

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
---------------
Jacob Skaria


"C Kreig" wrote:

Good morning Jacob-
When I use that formula it put the word true in the value.

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"C Kreig" wrote:

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.

Formula - If Statement with blank
 

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.
--
David Biddulph

"C Kreig" wrote in message
...
Good morning Jacob-
When I use that formula it put the word true in the value.

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"C Kreig" wrote:

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.