| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
simple sum question
I am using the sum feature on a large spreadsheet where one total might not
be complete and yields a #VALUE!. Is there a way to make this appear 0. I am using a simple =A13*G13 formula. Any help is greatly aprpeciated. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
simple sum question
You can use
=IF(ISERROR(A13*G13,0,A13*G13) -- HTH Kassie Replace xxx with hotmail "smiley61799" wrote: I am using the sum feature on a large spreadsheet where one total might not be complete and yields a #VALUE!. Is there a way to make this appear 0. I am using a simple =A13*G13 formula. Any help is greatly aprpeciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple Question?? | Excel Discussion (Misc queries) | |||
| simple IF question | Excel Discussion (Misc queries) | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Very simple question. | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Hybrid Mode
