Putting data into cells with formulas

[Guest]

Is it possible to put data into a cell that already has a formula? I want to know the % that A2 is from A1, however I want to put the number 23 in A2 manually and then have A2 have the answer which is .92. Impossible?

A1-2
A2-2

 

[Frank Kabel]

Hi
not possible with formulas. This would require VBA / using
an event procedure

-----Original Message-----
Is it possible to put data into a cell that already has a

formula? I want to know the % that A2 is from A1, however
I want to put the number 23 in A2 manually and then have
A2 have the answer which is .92. Impossible?

 

[Earl Kiosterud]

Elm,

you'd put the formula in a different (third) cell.

=A2/A1 formatted for percent.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Is it possible to put data into a cell that already has a formula? I want

to know the % that A2 is from A1, however I want to put the number 23 in A2
manually and then have A2 have the answer which is .92. Impossible?