# easy way to apply formula to each cell?

This is a discussion on easy way to apply formula to each cell? within the Excel Questions forums, part of the Question Forums category; I'm not a big excel user, so this is probably an easy question that I can't seem to figure out. ...

1. ## easy way to apply formula to each cell?

I'm not a big excel user, so this is probably an easy question that I can't seem to figure out. I am working with a price list, and I am attempting to take 5% off the price of each item listed. I need to replace each existing full price with the new, reduced price. The formula I am using is: (ie)

=29*(1-5%)

As the price list is rather long, is there an easy way to replace each existing price? Or at least place the new prices in the column next to the old price? [using: =B2*(1-5%)].... because it sure doesn't seem to work when i copy and paste!

Thanks

Nicks.

GO LEAFS!

2. ## Re: easy way to apply formula to each cell?

Put .95 in any blank cell.

Copy it.

Select all prices.

Hit Edit-Paste special-Multiply.

3. ## Re: easy way to apply formula to each cell?

Originally Posted by NyX
I'm not a big excel user, so this is probably an easy question that I can't seem to figure out. I am working with a price list, and I am attempting to take 5% off the price of each item listed. I need to replace each existing full price with the new, reduced price. The formula I am using is: (ie)

=29*(1-5%)

As the price list is rather long, is there an easy way to replace each existing price? Or at least place the new prices in the column next to the old price? [using: =B2*(1-5%)].... because it sure doesn't seem to work when i copy and paste!

Thanks

Nicks.

GO LEAFS!
Nick,
Your formula seems fine. How are you doing the copy and paste? Have you tried the fill down? Can you list the results you are getting as well as the Column B Values for a few of the entries? I'm always willing to help another Leafs fan.

4. ## Re: easy way to apply formula to each cell?

Well from what I have been told by a few self-proclaimed excel-perts, all I have to do is copy the original formula and paste it down the column. When I do this, the cell numbers change within the formula, but the answer just stays the same... and I get this: (ie)

\$5.00 [B2*(1-5%)] \$4.75
\$10.00 [B3*(1-5%)] \$4.75
\$15.00 [B4*(1.5%)] \$4.75 etc...

clearly, this is wrong.

Hopefully we won't be completely embarrassed in game 6...

Nicks.

5. ## Re: easy way to apply formula to each cell?

You know what I missed Dreamboat's reply... i just tried it and it worked... i understand now.

Thank you both very much. :D

Happily upon my way,

Nicks.

Leafs will take Philly next game, 4 - 1

6. ## Re: easy way to apply formula to each cell?

Philly???? Say it isn't so!

LOL!!

7. ## Re: easy way to apply formula to each cell?

Originally Posted by NyX
You know what I missed Dreamboat's reply... i just tried it and it worked... i understand now.

Thank you both very much. :D

Happily upon my way,

Nicks.

Leafs will take Philly next game, 4 - 1
I would laugh, but I think I will wait until the Leafs take Philly out 3-0. So THERE. Course I will be biting my nails the whole game, and if you aren't you should be. Remember we beat you both games in TO as well, and while we didn't wipe the floor with you, remember what happened to Ottawa when we got beat bad(3 Shut outs Baby). Eddie's going be looking for Philly Steak tomorrow.

8. ## Re: easy way to apply formula to each cell?

Have you recalulated?

Go to Tools -> Options -> Calculation and check to see if Manual or Automatic is selected. If you prefer to have Manual selected (for example, if you have a weak machine, would like recalc at the same time and get something to drink while the machine is recalculating), you just need to press F9 to recalculate or Ctrl + Alt + F9 to recalculate the whole Workbook. If there's not many calculations or your machine has lots of memory, then I would just put it on Automatic to automatically calculate any changes.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•