zero out estimates when actuals are entered

M

M. Earll

Hi, Using Excel XP for a budget program...how do I get cells in the
column of "estimated" totals to zero out when I enter amounts in the
next column of "actual" totals. I've done the IF function formula
(F10>"0","0") I copied to the rest of the column but when I enter new
figures - it deletes the formula. Is this possible and how can it be
done...and thank you, thank you if it can.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top