|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 20th, 2006, 04:33 PM
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
November 20th, 2006, 04:49 PM
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
November 21st, 2006, 03:14 AM
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
November 21st, 2006, 05:13 PM
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
November 21st, 2006, 05:19 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
