# Excel formula

Discussion in 'Mac Apps and Mac App Store' started by YS2003, Jul 7, 2009.

1. ### YS2003 macrumors 68020

Joined:
Dec 24, 2004
Location:
Finally I have arrived.....
#1
Can someone tell me the quickest way to set up a formula for the following?

I have an Excel file which containers 2 sheets. One sheet is the net cost and the other is selling rate. I would like to come up with the selling rate on the sheet A by adding certain amount on the net cost on the sheet B. There are so many cells and I cannot really do manually one by one linking a cell in A with a cell B with additional amount.

2. ### thegoldenmackid macrumors 604

Joined:
Dec 29, 2006
Location:
dallas, texas
#2
Assume we use cells a1 and b1, as opposed to sheets.
in a1 type "=b1 (net cost) + x (additional fee)" (obviously without the parentheses)

then just edit, fill down

3. ### YS2003 thread starter macrumors 68020

Joined:
Dec 24, 2004
Location:
Finally I have arrived.....
#3
V stands for any number.

Sheet A (selling price)
A B C D E F G H ......
1
2
3
4
5
6
.
.
.

Sheet B (net cost)
Sheet B (selling price)
A B C D E F G H ......
1 V V V .......
2 V V V ......
3 V
4 V
5 ...
6 ...
.
.
.

Somewhere on Sheet A or B, I am going to enter a number for the mark up to come up with the selling price for Sheet A.

So far, I am typing (or clicking the cell) this for each cell on Sheet A:
='File Name (SheetB)'!A1+'File Name (SheetB)'!Z100

Z100 is the cell in which I enter the number to come up with the selling price. I am going to add Z100 on the values on Sheet B (net pricing) to come up with the selling price on Sheet A.

This typing and clicking is so tedius as there are so many cells. Is there a way to copy all the relevant cells on Sheet B and copy them over to Sheet A while adding a number (as a mark up accross the board)?