Results 1 to 2 of 2

Thread: Calculating margin % and adjusting pricing

  1. #1
    Neophyte GottaBeKD182's Avatar
    Join Date
    May 2013
    Location
    A, A
    Posts
    1
    Articles
    0

    Calculating margin % and adjusting pricing



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hey everyone,


    I have a rather large project that's been dropped in my lap and I'd like to see if there's a simpler way of doing it.


    I have an Excel sheet with 1400+ lines of SKU's and pricing that I need to adjust. I need to find out the margin % of each one first, then adjust each one to the range I've been told to change them to. I've managed to properly find the margin % on the first line, so I know how to do it, but having to input this formula =(D2-C2)/D2*100 into each row, then changing the cell numbers for each line is of course remarkably tedious.


    There HAS to be an easier way to do this. Does anyone know? I've attached a copy of the Excel file (minus SKU numbers and descriptions for privacy reasons) if that helps.


    My sanity thanks you.


    Kyle
    Attached Files Attached Files

  2. #2
    Hello there,

    in E2 use: =IF(D2=0,0,(D2-C2)/D2*100)

    This stops you from getting Divide by Zero errors

    Once you have the formula in, press Enter then reselect E2. Have a good look a the dark black box around E2. You'll see that in the bottom right corner of the active cell border there is a small black square. This is called the ANCHOR. Double Click it and the formula will be copied all the way down to the last row of your data.

    Greg

Posting Permissions

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