Hi
I'm trying to produce a formula that double the value of the total everytime another sell increases by 1.
H3 is currently =D3*F3, what I need to do is if :
G3 = 0 it shows normal value of D3*F3
G3 = 1 it doubles (D3*F3)
G3 = 2 it double the previous doubled value
G3 = 3 it double the previous doubled value
and so on...
Is this possible?
I'm trying to produce a formula that double the value of the total everytime another sell increases by 1.
H3 is currently =D3*F3, what I need to do is if :
G3 = 0 it shows normal value of D3*F3
G3 = 1 it doubles (D3*F3)
G3 = 2 it double the previous doubled value
G3 = 3 it double the previous doubled value
and so on...
Is this possible?