| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Differenec formula: Dnt need '0' as a result;Rather have a blank c
Hi,
I have an excel sheet with data in columns A & B on TAB 1 and I am trying to have the DIFFERENCE of TAB 1-Cell A1 & B1 in TAB 2-Cell A1. My Cells A1 & B1 of TAB1 are empty (have nothing in them) and when I apply the formula I get "0" as result in Cell A1-TAB 2. Is there a way to NOT get '0' in the result cell with the formula still being in there even when your data cells are empty? Please help. Thanks Regards Rum |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a gap when the result of a formula is blank or zero | Charts and Charting in Excel | |||
| formula result blank | Excel Worksheet Functions | |||
| How to get Blank into a cell as a result of a formula | Excel Worksheet Functions | |||
| Pasteing formula gives blank result | Excel Worksheet Functions | |||
| IF statement when formula result is blank | Excel Worksheet Functions | |||
Threaded Mode
