Global formula

G

George_Papas

How can I apply a formula to a range of cells without entering into each
cell. I have a spreadsheet with values and want to convert to another
currency value.
 
P

Peo Sjoblom

No need for a formula although it is probably better using one, for instance
you can
use a help column and put a formula like

=A2*rate

then just copy down

or you can put the conversion rate in a cell, copy it, select the range and
do edit>paste special and select multiply


Regards,

Peo Sjoblom
 
Top