Utilizing a Cell even when a Formula is present

  • Thread starter Ahh, Excel's tough
  • Start date
A

Ahh, Excel's tough

Hi, I'm completely new to this board and was wondering if I could
possibly get some help. I'm trying to utilize a cell in which has a
formula in it, however everytime I insert a value to utilize the
formula, it of course.., gets cleared out. Is there anyway to maintain
the formula inside the cell, then be able to just type a basic number
into the cell and have the formula calculate. The formula I have now
is =IF(A2=0, B2=0,""), I need when A2 is empty, for B2 to empty itself
out. However, I need when A2 has something in it, for C2 to subtract
the value from B2, but I can't if the formula doesn't stay put. Thanks
in advance!
 

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

Similar Threads

(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Subtracting 37 hours from a cell containing format [h]:mm 2
Utilizing a Cell even with a Formula located inside it 4
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Avoiding auxiliary cells 0
Copying formulas across columns 2
Ignoring Blank cells 9
Copying Formulas 3

Top