| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISBLANK IF STATEMENT
I HAVE A FIELD THAT CALCULATES THE AVERAGE DAYS TAKEN TO SEND CORRESPONDANCE.
THE FORMULA IN THIS CELL( H4) IS =SUM(G4-A4) THE PROBLEM IS THAT IF THERE IS NO VALUE IN CELL (G4) THE VALUE RETURNED TO (H4) IS -39818. IS THERE A WAY TO GET (H4) TO RETURN A VALUE OF ZERO (0)IF G4 IS EMPTY |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK IF STATEMENT
PDUB wrote...
I HAVE A FIELD THAT CALCULATES THE AVERAGE DAYS TAKEN TO SEND CORRESPONDANCE. THE FORMULA IN THIS CELL( H4) IS =SUM(G4-A4) THE PROBLEM IS THAT IF THERE IS NO VALUE IN CELL (G4) THE VALUE RETURNED TO (H4) IS -39818. IS THERE A WAY TO GET (H4) TO RETURN A VALUE OF ZERO (0)IF G4 IS EMPTY if G4 would always be greater than A4 when G4 isn't blank, =max(G4-A4,0) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK IF STATEMENT
=IF(G4="",0,G4-A4)
-- Gary''s Student - gsnu200825 "PDUB" wrote: I HAVE A FIELD THAT CALCULATES THE AVERAGE DAYS TAKEN TO SEND CORRESPONDANCE. THE FORMULA IN THIS CELL( H4) IS =SUM(G4-A4) THE PROBLEM IS THAT IF THERE IS NO VALUE IN CELL (G4) THE VALUE RETURNED TO (H4) IS -39818. IS THERE A WAY TO GET (H4) TO RETURN A VALUE OF ZERO (0)IF G4 IS EMPTY |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK IF STATEMENT
Firstly, please get your caps lock key repaired so that you can stop
SHOUTING. Secondly, you seem to have lost part of your SUM formula. You have given the SUM function only one argument (G4-A4), and not told it what other arguments you want to sum with it. If you want just G4-A4, the formula is =G4-A4 and you don't need the SUM function. [If you want to know how to use the SUM function, look it up in Excel help.] Perhaps what you want is =IF(G4="",0,G4-A4) ? -- David Biddulph PDUB wrote: I HAVE A FIELD THAT CALCULATES THE AVERAGE DAYS TAKEN TO SEND CORRESPONDANCE. THE FORMULA IN THIS CELL( H4) IS =SUM(G4-A4) THE PROBLEM IS THAT IF THERE IS NO VALUE IN CELL (G4) THE VALUE RETURNED TO (H4) IS -39818. IS THERE A WAY TO GET (H4) TO RETURN A VALUE OF ZERO (0)IF G4 IS EMPTY |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK IF STATEMENT
try
=IF(ISBLANK(G4),0,G4-A4) Does this do what you want? If not, post back HTH -- If this posting is helpful, appreciate that you click on the Yes button below Thank You cheers, francis "PDUB" wrote: I HAVE A FIELD THAT CALCULATES THE AVERAGE DAYS TAKEN TO SEND CORRESPONDANCE. THE FORMULA IN THIS CELL( H4) IS =SUM(G4-A4) THE PROBLEM IS THAT IF THERE IS NO VALUE IN CELL (G4) THE VALUE RETURNED TO (H4) IS -39818. IS THERE A WAY TO GET (H4) TO RETURN A VALUE OF ZERO (0)IF G4 IS EMPTY |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK IF STATEMENT
That worked beautifully!
Thank You! -- PDUB "xlmate" wrote: try =IF(ISBLANK(G4),0,G4-A4) Does this do what you want? If not, post back HTH -- If this posting is helpful, appreciate that you click on the Yes button below Thank You cheers, francis "PDUB" wrote: I HAVE A FIELD THAT CALCULATES THE AVERAGE DAYS TAKEN TO SEND CORRESPONDANCE. THE FORMULA IN THIS CELL( H4) IS =SUM(G4-A4) THE PROBLEM IS THAT IF THERE IS NO VALUE IN CELL (G4) THE VALUE RETURNED TO (H4) IS -39818. IS THERE A WAY TO GET (H4) TO RETURN A VALUE OF ZERO (0)IF G4 IS EMPTY |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK IF STATEMENT
I'm sorry I was working with the ISBLANK and forgot to click it off.
-- PDUB "David Biddulph" wrote: Firstly, please get your caps lock key repaired so that you can stop SHOUTING. Secondly, you seem to have lost part of your SUM formula. You have given the SUM function only one argument (G4-A4), and not told it what other arguments you want to sum with it. If you want just G4-A4, the formula is =G4-A4 and you don't need the SUM function. [If you want to know how to use the SUM function, look it up in Excel help.] Perhaps what you want is =IF(G4="",0,G4-A4) ? -- David Biddulph PDUB wrote: I HAVE A FIELD THAT CALCULATES THE AVERAGE DAYS TAKEN TO SEND CORRESPONDANCE. THE FORMULA IN THIS CELL( H4) IS =SUM(G4-A4) THE PROBLEM IS THAT IF THERE IS NO VALUE IN CELL (G4) THE VALUE RETURNED TO (H4) IS -39818. IS THERE A WAY TO GET (H4) TO RETURN A VALUE OF ZERO (0)IF G4 IS EMPTY |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK IF STATEMENT
You're welcome, glad that it work for you.
Thank you for your feedback. -- If this posting is helpful, appreciate that you click on the Yes button below Thank You cheers, francis "PDUB" wrote: That worked beautifully! Thank You! -- PDUB "xlmate" wrote: try =IF(ISBLANK(G4),0,G4-A4) Does this do what you want? If not, post back HTH -- If this posting is helpful, appreciate that you click on the Yes button below Thank You cheers, francis "PDUB" wrote: I HAVE A FIELD THAT CALCULATES THE AVERAGE DAYS TAKEN TO SEND CORRESPONDANCE. THE FORMULA IN THIS CELL( H4) IS =SUM(G4-A4) THE PROBLEM IS THAT IF THERE IS NO VALUE IN CELL (G4) THE VALUE RETURNED TO (H4) IS -39818. IS THERE A WAY TO GET (H4) TO RETURN A VALUE OF ZERO (0)IF G4 IS EMPTY |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF AND ISBLANK | Excel Worksheet Functions | |||
| ISBLANK() | Excel Worksheet Functions | |||
| isBlank() | Excel Worksheet Functions | |||
| Adding A Not(IsBlank) To IF Statement(help) | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
Linear Mode
