Forum Discussion
Solved
Maintaining formulas in the cell
How do I keep this message (formula) in the cells after editing-Deleting values in the cells Staff Loan Enter Amount Staff Mortgage Enter Amount The formula is =IF($G$4=F8, 0,"Enter ...
David_Kahuhu OK so i changed the formula to:
=IF(($H$4<>F8)*(H8=""),"Enter Amount","")see attached. But you can make the formula anything you want. My real point was to show you how you could use this 'trick' to have that text appear to show in that cell.
Thanks mtarler
Sorry for the confusion, I wanted a formula that will display Enter Amount when cell H8 when H4 is not staff Loan, display H9 Enter Amount when H4 is not Staff Mortgage and display Enter Amount when H4 is Not overdraft.
Your assistance will be highly appreciated
David_Kahuhu OK so i changed the formula to:
=IF(($H$4<>F8)*(H8=""),"Enter Amount","")see attached. But you can make the formula anything you want. My real point was to show you how you could use this 'trick' to have that text appear to show in that cell.