Utilizing a Cell even with a Formula located inside it

[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!

 

[Pete_UK]

You need to put the formula in C2, something like:

=IF(A2="","",B2-A2)

So, if A2 is empty then C2 will also appear empty, but if A2 contains
some value then it will be subtracted from B2 and the result will
appear in C2.

Hope this helps.

Pete

 

[Ahh, Excel's Tough]

You need to put the formula in C2, something like:

=IF(A2="","",B2-A2)

So, if A2 is empty then C2 will also appear empty, but if A2 contains
some value then it will be subtracted from B2 and the result will
appear in C2.

Hope this helps.

Pete



- Show quoted text -

Thanks for the reply Pete, sorry about the multipost. I'll be sure to
try this tomorrow afternoon and keep you updated!

 

[Ahh, Excel's Tough]

Thanks for the reply Pete, sorry about the multipost. I'll be sure to
try this tomorrow afternoon and keep you updated!- Hide quoted text -

- Show quoted text -

Actually, just had time to try it out. I might be typing out the
formula wrong, but if not, I'm still having a bit of difficulty. I'm
in no way Excel (Powerpoint and Word is one thing but Excel is
another) advanced, so I hope you can bare with me. Right now my
formula is stuck at
=IF(C2="=IF(A2=0,"",PRODUCT([YearlySummary.xls]Lookup!$B$2,8)-
B:B)","",""). However, with this formula, the user would have to
manually go up to the formula bar and type in numbers between the
quotation marks. Is there anyway I can possibly have the user type the
number in the box, and have the formula work that way? I have that
formula currently in Column B, but since I need to subtract Column B
from Column C, it won't work out.

 

[Pete_UK]

Just read my response again - you type the formula in C2 and when you
press Enter you will have a blank in C2 (if A2 is blank) or the result
of B2-A2 (if A2 contains a value). Your users will enter values in
either A2 or B2 and C2 will show the appropriate result.

If you are dealing with different cell references, then just
substitute them directly.

Hope this helps.

Pete

Thanks for the reply Pete, sorry about the multipost. I'll be sure to
try this tomorrow afternoon and keep you updated!- Hide quoted text -

- Show quoted text -

Actually, just had time to try it out. I might be typing out the
formula wrong, but if not, I'm still having a bit of difficulty. I'm
in no way Excel (Powerpoint and Word is one thing but Excel is
another) advanced, so I hope you can bare with me. Right now my
formula is stuck at
=IF(C2="=IF(A2=0,"",PRODUCT([YearlySummary.xls]Lookup!$B$2,8)-
B:B)","",""). However, with this formula, the user would have to
manually go up to the formula bar and type in numbers between the
quotation marks. Is there anyway I can possibly have the user type the
number in the box, and have the formula work that way? I have that
formula currently in Column B, but since I need to subtract Column B
from Column C, it won't work out.- Hide quoted text -

- Show quoted text -