| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
b;ank cells in calculations
I use the IF function, in order to get some blank cells like:
A1: IF(E1F1;E1-F1;"") and B1: IF(F1E1;F1-E1;"") and: A2: IF(E2F2;E2-F2;"")and B2: IF(F2E2;F2-E2;"") However, that empty string doesn't allow me to use any of the blank cells in a new calculation, giving me a #VALUE! error. For example: A3: =A1+A2 or B3: =B1+B2 Is there a workaround? (please note that I want those cells totally blank and not with a zero value) -- geotso ---- ---- --- -- -- - - Please, remove hyphens to contact me ---- ---- --- -- -- - - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you perform calculations w/ cells that have both numbers and t | Excel Worksheet Functions | |||
| Performing calculations on only cells with data | Excel Worksheet Functions | |||
| Calculations of cells | Excel Discussion (Misc queries) | |||
| Calculations on Only Unhidden Data Cells | Excel Discussion (Misc queries) | |||
| blank cells in calculations | Excel Worksheet Functions | |||
Threaded Mode
