Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
use vlook to show the value of a cell using a formula | Excel Discussion (Misc queries) | |||
Is it possible? | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Cell Reference Embedded in Formula | Excel Worksheet Functions |