excel formula

[logan19]

cell A1 is the starting amount, cell A2 is the amount to deduct, cell A3 is the remainder. So formula for cell A3 will be =SUM(A1-A2).
I want to input the amount in cell A2 but I want cell A2 to remain blank after after the total for cell A3 is calculated.
Does anyone know how i do this

 

[Becky]

Hello and welcome to the forum!

I'm not sure what you mean... if you want it to look blank you could always make the text white so that it's not visible? Or perhaps hide the whole column if after you have input the data (right click on the top of the column then select hide)? I'm not sure if this is what you mean though.