| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If blank statement | Excel Discussion (Misc queries) | |||
| if statement when cell is blank | Excel Worksheet Functions | |||
| add blank row in an if statement | Excel Discussion (Misc queries) | |||
| "If" statement returning blank gives downstream formula errors. | Excel Discussion (Misc queries) | |||
| IF statement when formula result is blank | Excel Worksheet Functions | |||
Linear Mode
