Excel Help

[GravityGirl 0]

I have a worksheet full of prices.

I would like to apply the same formula (Cost / 4) to all prices on the spreadsheet. Thus reducing the value in all cells by 3/4.

Is there a way to do this all at once, or do I have to do it cell by cell?

And no, this does NOT indicate the mark up for skydiving gear!!!! I wish.

~~~~~~~~~~~~~~~~~
Peace and Blue Skies!
Bonnie ==>Gravity Gear!

[kelel01 1]

Type the formula in the first cell and hit enter, then move the cursor over the bottom right-hand corner of the cell until a black cross appears. Click, hold, and drag down through all cells in which you want to apply the formula.

Let me know if it doesn't work.

[sum1mom 0]

Am I seeing this too simplified?

cell (a1) * .75 = new price copy formula through new column....done.

[Remster 30]

Well, if she types the formula in the 1st cell, it will replace the price and have a circular error! lol

Try doing that, but on a new sheet for that file: call it page 2, or new prices, or wathever... the formula will be something like this:

=SHEET1:a1/4


Then côpy that over all the range to reproduce the original

Remster

[sum1mom 0]

good idea...or just simply insert a new column next to the old prices with the new formula.

[Rebecca 0]

You can even double-click when you see the black cross and it will auto-fill the formula to the bottom of the data.

you've got to ask yourself one question: 'Do I feel loquacious?' -- well do you, punk?

[kelel01 1]

Sorry . . . he's right. But you don't need a new worksheet if it's only a column or a row of prices.

You could insert a blank column or row and do it right beside it.

[Rebecca 0]

That's what I was talking about. Here, I'll see if I can attach something...

you've got to ask yourself one question: 'Do I feel loquacious?' -- well do you, punk?

[Remster 30]

Quote

That's what I was talking about. Here, I'll see if I can attach something...

Well, I like working with new sheets to make sure that its easy to just copy and paste values over to a new file, if, she needs to send stuff to sub-dealers for exemple...

Remster

[GravityGirl 0]

That just copies the formula for that cell into the others or copies the value into the cells I'm dragging in to.

I am trying to take a spreadsheet with lots of prices and reduce the value of each cell by 75%.

A jump ticket to the first person who comes up with a solution!

~~~~~~~~~~~~~~~~~
Peace and Blue Skies!
Bonnie ==>Gravity Gear!

[sum1mom 0]

see above edit.

[vdschoor 0]

Quote

That just copies the formula for that cell into the others or copies the value into the cells I'm dragging in to.

I am trying to take a spreadsheet with lots of prices and reduce the value of each cell by 75%.

A jump ticket to the first person who comes up with a solution!

Gimme a call you know the number

[wartload 0]

If I understand your question correctly, try this:

Say that the figures that you want to reduce by 3/4 are all in colum C of your application (so C1 would be the first cell to have that figure). Go into the next unused column and type in:

=C1*.75

This gives you 3/4 of the original price. If you want 1/4 of it, use

=C1*.25

Then copy & paste that cell to all of the rest of the blank cells in the column where you want your answers. You can right-click on the cell with your equation, choose COPY, then left click on the next blank cell down and drag the cursor down to highlight all of the cells that you want. Then right-click in that and choose paste.

[wildblue 7]

insert column
put a 4 at the top, click the 4, hold shift click last in that column
ctrl-d
copy colums with prices
click top "4"
paste special and pick divide.

EDIT:
Oh... you have prices all over the sheet? not just in one column? Nevermind then, use the formula idea

it's like incest - you're substituting convenience for quality

[Remster 30]

There you go

Remster

[kelel01 1]

Remster was right. You need a new worksheet then.

Say the first cell on your first spreadsheet with a price in it is B1.

Go to the next worksheet and type =, then go back to sheet 1 and click on cell B1. Then go back to the other spreadsheet and after the text it put in there from clicking on the cell, type "/4" without the quotes.

Hit enter. It should give you the value of B1/4.

Then get the little black cross I was talking about and drag it to the area of the prices you have. So if the prices go 20 columns wide and 20 rows down, drag the little black cross over 20 columns, and down 20 rows. Let it go, and all values should show divided by 4.

[Remster 30]

Quote

Remster was right.

Why cant people understand this simple concept?

Remster

[sum1mom 0]

[mnealtx 0]

Two ways:

If the current cost cell contains a formula that creates the price, enclose everything except the "=" in parentheses, then add "/4" behind it.

Click/drag the cross in the lower right corner down the column to transfer the changes to the rest of the column, as stated above.

Second way: Create column to the right of the cost column, make the formula in the first cell " =xy/4", where xy is the location of the cost cell. Click/drag as before...

Mike
I love you, Shannon and Jim.
POPS 9708 , SCR 14706

[GravityGirl 0]

Done!

I had everything right except one thing! I was copying the spreadsheet to another FILE instead of worksheet, and it didn't want to play!

So Remster you had the same idea as I did. You just knew how to do it right.

Now. Who can help me decide who to send the jump ticket to? So many contributors. This site rocks!

~~~~~~~~~~~~~~~~~
Peace and Blue Skies!
Bonnie ==>Gravity Gear!

[Remster 30]

Quote

So Remster you had the same idea as I did. You just knew how to do it right.

Now. Who can help me decide who to send the jump ticket to?

You have to ask?

Remster

[lummy 4]

if they prices in columns, then do like someone else suggested in a column to the right of the price (see quote). for example, the price is in C1, then type in D1 "=c1*.75

Quote

If I understand your question correctly, try this:

Say that the figures that you want to reduce by 3/4 are all in colum C of your application (so C1 would be the first cell to have that figure). Go into the next unused column and type in:

=C1*.75

This gives you 3/4 of the original price. If you want 1/4 of it, use

=C1*.25

now, highlight the formula in D1. move the mouse to the lower right hand corner. That corner will turn into a PLUS sign. Once it does Left click on the plus sign and drag the mouse down to the last price in the column.
If you click on D2 and look, the formula in that field says C2*.75 What this does is to automatically increment the cell #'s

Same concept if you are working in rows, just drag the mouse right instead of down

I promise not to TP Davis under canopy.. I promise not to TP Davis under canopy.. eat sushi, get smoochieTTK#1

[genoyamamoto 0]

Bon,
I'm a nice guy so to make it simple you can just put zeros next to all the stuff I order.

Gotta go... plaything needs to spank me
Feel the hate...
Photos here

[happythoughts 0]

[lurking 0]

You have obviously solved your problem. But for reference I will contribute my solution. I use it a lot for situations where I have started a spreadsheet with Dollar- or Euro-amounts and only later figure out I want it done in thousands of Euro or Dollar.

This solution permanently converts the amounts and does not use any extra columns, sheets or files.

Here goes (please note that I am in front of a German excel version and translating the commands. They could be called slightly different):

- Go to a single unused cell and enter the value you want to divide by (in your case a 4)

- Still on that cell use the "copy" command (Ctrl-C)

- Highlight the cells in your price column

- Use "Insert Content" (or whatever it may be called. It´s the command under the normal Insert-command in the edit menu)

- In the box that appears choose "divide" on the lower right of the box.

This will permanently divide all cell values in the highlighted area by the value you copied.

You can now delete the cell where you put the "4". There is no reference to that cell.

Hope this helps somebody...