Excel formula

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

  1. YS2003 macrumors 68020

    YS2003

    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

    thegoldenmackid

    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

    YS2003

    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)?
     

Share This Page