Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing "0" from insert
I'm using this formula in one of my cells =Sheet2!E2 but if there is no info
type in from that sheet then my return input is "0" how do I remove the "0" from ever appearing, just a blank would be great. I've saw a posting for ADDING cells and if a number is not inserted then the return would be 0. and they fixed the problem with this type of formula =IF(A1 + B1 = 0,"",A1 + B1). How would I uses the with the formula that i'm using from another sheet, as mention above? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simultaneouly insert of rows or col. - Ajit | Excel Discussion (Misc queries) | |||
insert picture | Excel Discussion (Misc queries) | |||
Insert Line Macro | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |