Do I need temporary cell?

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

I have the following cells. I'm using money from F76 to calcuate a
new value for D80. If F76 is greater than $0.00, I'd like to apply
that money to D80.

D80 = $-1193.20
F76 = $116.57
F80 = IF(F76>0,F76+D80,) = -$1076.63

Using the above example, since I've taken the $116.57 from F76 and
applied it to D80 (result is F80), how do I zero out F76 without
affecting the formula in F80? I'd like to avoid using hidden cells or
those with white text. I have a few cells that need to work this way
and it will create extra holding cells all over the place. Any
suggestions?

Thanks,
Brett
 
Hi
this can't be done with formulas. This would require macros (event
procedures) as formulas can't change other cells
 
Hi

You almost did it. Into F80 enter the formula
=IF(F76>0,D80+F76,D80)
Same result will give you also
=F80+(F76>0)*F76
 
Maybe I wasn't clear but this isn't what I'm looking for. I'm not
sure exactly what you are doing.

I need F76 to be zero since I have taken its money. Your formula
doesn't do this. The problem is that if I change F76 to zero, it will
change the value of F80.

Brett
 
Hi!

As Frank said, you will have to use VBA to do that. Otherwise Exce
would be locked into circular references.

Al
 
Back
Top