Clearing a cell

F

frustratedwthis

Hello All

How can I clear the amount out of one cell when an amount is entered in
another cell?

Thanks for the help!
 
N

Nick Hodge

You could use an IF function

e.g if you want "No" in B1 when nothing is in A1 then B1 to be blank on any
entry in A1 then in B2 enter

=IF(A1<>"","No","")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top