Apply Formula To Cell

[joesmithf1]

Hi All,
This seems to be an easy task but I just can't figure it out; I have looked every where. Here is what I want to do. I have a spreadsheet with 500 rows and 50 columns. All of them have different values in each cell. Now, I want to divide each cell by 10. How can I do this? I have tried to apply a 'function' to the A1 cell by doing this: =A1/1 Then I do a copy to copy the formula and apply to the rest of the cells. It is NOT working because what Excel is actually doing is it copy the values from A1 and apply to all the rest. Does this make any sense? Please help.

Thank you.

Joe

[MrShorty]

Perhaps you are looking to:
1) put 10 in an empty cell.
2) copy that cell to the clipboard.
3) Select range of values to apply to
4) Edit->paste special->divide

The values in your range should be 1/10th of their original values.

[joesmithf1]

Wow...this works! I have never thought of it this way. Thank you MrShorty!

Now I have a more complicated question. What if I want to apply more calculations to the cells? For example, I want to divide the cells by 10, multiply it by 8.725% of tax, then add $5 for shipping fee?

Can't I just write a formula somewhere and then apply the formula to the cells?

Thank you.

Joe

[starguy]

Wow...this works! I have never thought of it this way. Thank you MrShorty!

Now I have a more complicated question. What if I want to apply more calculations to the cells? For example, I want to divide the cells by 10, multiply it by 8.725% of tax, then add $5 for shipping fee?

Can't I just write a formula somewhere and then apply the formula to the cells?

Thank you.

Joe

you can repeat the Paste Special function to do these tasks.
after dividing by 10.
put 1.08725 in empty cell, copy that cell, select the range of cells you want to multiply with 8.725%, right click, click Paste Special and check Multiply option.
then put 5 in empty cell and copy it and select the range then right click > Paste Special > Add.

you can also do this by following formula
I suppose your data is in cell A1 downwards, put in B1

=((A1/10)*1.08725)+5 and copy it down.

(its better to use another sheet to get results after applying this formula)

Regards.