retaining functions or formulas in cells
Is it possible to retain functions or formulas in cell in such a way that if
it returns no data one can type data into the cell but retain the function or formula so that when data does become available in the refered to sheet it will respond to it? Thanks! Ed |
retaining functions or formulas in cells
A cell contains a formula or it doesn't. You can't have both.
But you can use some helper cells to give that kind of effect. Say your formula is in C2 you can put the manual entry in D2 and in E2, you could decide which to use =if(d2<"",d2,c2) And use E2 in all your subsequent formulas. milkman wrote: Is it possible to retain functions or formulas in cell in such a way that if it returns no data one can type data into the cell but retain the function or formula so that when data does become available in the refered to sheet it will respond to it? Thanks! Ed -- Dave Peterson |
retaining functions or formulas in cells
That is helpful!! Thanks Dave.
Ed "Dave Peterson" wrote: A cell contains a formula or it doesn't. You can't have both. But you can use some helper cells to give that kind of effect. Say your formula is in C2 you can put the manual entry in D2 and in E2, you could decide which to use =if(d2<"",d2,c2) And use E2 in all your subsequent formulas. milkman wrote: Is it possible to retain functions or formulas in cell in such a way that if it returns no data one can type data into the cell but retain the function or formula so that when data does become available in the refered to sheet it will respond to it? Thanks! Ed -- Dave Peterson |
All times are GMT +1. The time now is 07:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com