Hide Values when data has not been entered into a cell.
I am trying to create a spreadsheet that has date functions with sums. I
would like to have the cells that will be populated with the sum to be blank until the data is entered into the fuction Cell. Can anyone help? Thanks |
Hide Values when data has not been entered into a cell.
Maybe...
=if(a1="","",sum(c1:e1)) Then this cell will look empty until a value is entered in A1. Higgy wrote: I am trying to create a spreadsheet that has date functions with sums. I would like to have the cells that will be populated with the sum to be blank until the data is entered into the fuction Cell. Can anyone help? Thanks -- Dave Peterson |
All times are GMT +1. The time now is 12:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com