View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Formula Embedded in Cell

You could if you were very careful enter select the cell and type the value
in the formula bar at the appropriate point in the formula but this is very
awkward.
As soon as you begin to type directly in A1 your formula is deleted so you
must refernce another cell.

"Jeff" wrote:

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,