Do I need temporary cell?

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
 
F

Frank Kabel

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

Arvi Laanemets

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
 
B

Brett

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
 
A

AlfD

Hi!

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

Al
 

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

I need to cut characters off of a list of text cells... 2
Copy selection to temporary variable 1
How do I copy conditional formatting only? 5
conditionally formatting cells based on other cells 1
How do I use "sumif" for cells ">0" across multiple ranges? 2
How can I 'CountIf' alternate cells? 2
how do I average cells 4
After Macro runs, no cell activated - what am I missing? 2

Top