Putting data into cells with formulas

E

elm

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
 
F

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
Click to expand...
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?
 
E

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
-------------------------------------------

elm said:
Is it possible to put data into a cell that already has a formula? I want
Click to expand...
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?
 
Top