can you have a formula in a cell and still enter separate data on top of it as

[knesl69]

can you have a formula in a cell and still enter "separate" data on top of it as if the formula is hidden


so if Entered a number or text could the under lying formula act on the input


thanks Mark

 

[Hui]

No


Many years ago a DOS based spreadsheet called Open Access, no relation to MS Access had a function !


In use you could enter a formula into a cell eg: =!*(9/5)+32 (the formula to convert Deg C to Fahrenheit)

Then you could enter a value into the cell and the formula would use the value in the position of !

so in this example the formula would result in =20*(9/5)+32 = 68


This functionality isn't available in Excel.