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
HIS


"frustratedwthis" wrote in
message ...
Hello All

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

Thanks for the help!