J Jeff Mackeny Jun 8, 2004 #1 quick question, if I have the following formula =G4-D4-E4-H4 and the results is 0, how to keep the cell blank Vs the cell saying 0
quick question, if I have the following formula =G4-D4-E4-H4 and the results is 0, how to keep the cell blank Vs the cell saying 0
J JulieD Jun 8, 2004 #2 Hi Jeff two options tools / options / view tab - untick zero values or for only specific cells (and my preferred method) =if(G4-D4-E4-H4=0,"",G4-D4-E4-H4) Cheers JulieD
Hi Jeff two options tools / options / view tab - untick zero values or for only specific cells (and my preferred method) =if(G4-D4-E4-H4=0,"",G4-D4-E4-H4) Cheers JulieD
J Jeff Mackeny Jun 8, 2004 #3 thanks JulieD said: Hi Jeff two options tools / options / view tab - untick zero values or for only specific cells (and my preferred method) =if(G4-D4-E4-H4=0,"",G4-D4-E4-H4) Cheers JulieD Click to expand...
thanks JulieD said: Hi Jeff two options tools / options / view tab - untick zero values or for only specific cells (and my preferred method) =if(G4-D4-E4-H4=0,"",G4-D4-E4-H4) Cheers JulieD Click to expand...
