Clearing a cell
Hello All
How can I clear the amount out of one cell when an amount is entered in another cell? Thanks for the help! |
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! |
All times are GMT +1. The time now is 11:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com