Formula cells needs to display "zero"
How do i get a cell with a formula in it to display a zero until a figure is
typed into a corresponding cell? All productive help is greatly appreciated. -- thank you |
Assuming your formula is SUM(B1:B20), try: =IF(A1="",0,SUM(B1:B20)) Regards, KL "hello" wrote in message ... How do i get a cell with a formula in it to display a zero until a figure is typed into a corresponding cell? All productive help is greatly appreciated. -- thank you |
All times are GMT +1. The time now is 04:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com