adding formula to existing data

  • Thread starter Thread starter Brooke
  • Start date Start date
B

Brooke

I have a large spreadsheet with cells already filled with
data. I want to apply a formula to each cell using the
existing data in each cell. I know I can do this and it's
relatively easy without having to work in each cell
individually. would anyone know how to do this?

Thanks so much,
Brooke
 
the data represented US$. I needed to convert it to
Canadian $ then age it by 2%. so the formula would look
like =(xxx.xx*1.xxx)*1.02 in each cell using the existing
data in each cell.

This needed to be done last night so I actually manually
did this formula for both spreadsheets all the while
knowing there must be an easier way. This won't be the
last time I need to do this so I would still like to
understand.

Thanks for your response.

Brooke
 
Small Sample below:
Enter the following info into a blank Worksheet:
A B C D
1 125.00 1.25 << Conversion to Can $$'s
2 189.56 1.02 << Age it Up @%
3 205.12

Step 1: with cursor on Cell D1 - do a Copy (of the single cell),
then move to A1 and click drag down to A3 highlighting and let go,
then go to the Menu Edit, Paste-Special, click on Multiple, OK
things should now look like this:

A D
1 156.25 1.25
2 236.95 1.02
3 256.40

Step 2: with cursor on Cell D2 - do a Copy (of the single cell),
then move to A1 and click drag down to A3 highlighting and let go,
then go to the Menu Edit, Paste-Special, click on Multiple, OK
things should now look like this:

A D
1 159.38 1.25
2 241.69 1.02
3 261.53

Now erase Cells D1:D2
A1:A3 has been updated.
HTH
 
Oh my Goodness Thanks So Much!! I knew there was an
easier way. I will remember that for next time.

Brooke
 
Back
Top