Want the cell dosen't show anything then the value is zero. How I do that ?? // Sokoban
S Sokoban Oct 30, 2003 #1 Want the cell dosen't show anything then the value is zero. How I do that ?? // Sokoban
B Biff Oct 30, 2003 #2 Hi Sokoban, If I understand you correctly, just wrap your formula inside an IF function: =IF(YOUR_FORMULA=0,"",YOUR_FORMULA) or You can goto Tools>Options>View>Zero Values Biff
Hi Sokoban, If I understand you correctly, just wrap your formula inside an IF function: =IF(YOUR_FORMULA=0,"",YOUR_FORMULA) or You can goto Tools>Options>View>Zero Values Biff
S Sokoban Oct 30, 2003 #3 Thanks it works....with option. I don't understand your calculate with YOUR and FORMULA. What is this ??? // sokoban
Thanks it works....with option. I don't understand your calculate with YOUR and FORMULA. What is this ??? // sokoban
