Hi:
I am working on a spreadsheet and have entered a formula in cell A1
=IF('Deposit Form'!A11>"",'Deposit Form'!A11,"")
When I check my formula it shows the result I want however on cell A1 is showing the formula and not the result. Any idea how to change this? Maybe there is a better formula. I basically am saying that if A1 is blank then show blank, otherwise show the contents of A1
THANKS for your help,
Mark
I am working on a spreadsheet and have entered a formula in cell A1
=IF('Deposit Form'!A11>"",'Deposit Form'!A11,"")
When I check my formula it shows the result I want however on cell A1 is showing the formula and not the result. Any idea how to change this? Maybe there is a better formula. I basically am saying that if A1 is blank then show blank, otherwise show the contents of A1
THANKS for your help,
Mark