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

Utilizing a Cell even with a Formula located inside it 4
Subtracting 37 hours from a cell containing format [h]:mm 2
Excel formula, sum the value cell and if empty cell left blank 0
Drop-down list and error message 1
Averageifs - criteria is cell is not blank 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Excel VBA 1

Top