| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
I am trying to add two cells and ach cell contains a formaula. I keep getting
the error #VALUE! when one of cells does not produce a value Is there any way to avoid this Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#VALUE!
=IF(ISERROR(SUM(A1:A100)),"",SUM(A1:A100))
"Curtis" wrote: I am trying to add two cells and ach cell contains a formaula. I keep getting the error #VALUE! when one of cells does not produce a value Is there any way to avoid this Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#VALUE!
Would this still work if i neede to add two cells say j1+ak1?
"Teethless mama" wrote: =IF(ISERROR(SUM(A1:A100)),"",SUM(A1:A100)) "Curtis" wrote: I am trying to add two cells and ach cell contains a formaula. I keep getting the error #VALUE! when one of cells does not produce a value Is there any way to avoid this Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#VALUE!
The two cells in question that I need to add are J1 and AK1. This formula
does not produce the correct answer ANy thoughts? Thanks "Teethless mama" wrote: =IF(ISERROR(SUM(A1:A100)),"",SUM(A1:A100)) "Curtis" wrote: I am trying to add two cells and ach cell contains a formaula. I keep getting the error #VALUE! when one of cells does not produce a value Is there any way to avoid this Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#VALUE!
Sorry your formual works. I just needed to sum the two cells as
=IF(ISERROR(SUM(J1,AK1)),"",SUM(J1,AK1)) "Teethless mama" wrote: =IF(ISERROR(SUM(A1:A100)),"",SUM(A1:A100)) "Curtis" wrote: I am trying to add two cells and ach cell contains a formaula. I keep getting the error #VALUE! when one of cells does not produce a value Is there any way to avoid this Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
