| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoFIll -by dragging the bottom-right corner of the cell | Excel Discussion (Misc queries) | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
