Formula Embedded in Cell
Hi,
Is it possible to embed in cell A1 the following formula to return a
different value still in A1?
(0.12%*1000000000)+(0.1%*1000000000)+((((Value of
A1-1000000000)-1000000000)*0.08%))
I'd like to input a value in cell A1 then the formula (in the background)
will use A1 value and return the new calculated value in A1
Example: If I input a value for A1 = $4,421,005,516.00 then the new value
for A1
Should be (after calculation using the embedded formula) $4,136,804.41
Regards,
|