+ Reply to Thread
Results 1 to 5 of 5

simple - if x then x calculation

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    23

    simple - if x then x calculation

    I have a coworker who needs help with a calculation:

    If we increased the margin to 70%, what would the cost of the item be?
    (margin is currently calculated: (retail-cost)/cost = margin


    Item Cost Retail margin
    crabcake $1.00 $2.00 50.00%
    sandwich $2.00 $3.00 33.33%
    cake $1.25 $3.00 58.33%

    I was thinking it should be something like if retail =.70, then retail is XX. I just have no idea how to put that into a formula.

    Thanks!!!
    ds

  2. #2
    Registered User
    Join Date
    08-08-2007
    Location
    Vancouver
    MS-Off Ver
    Excel 2002, Excel 2007, Excel for Mac 2011
    Posts
    38

    Re: simple - if x then x calculation

    Retail = Cost / (1-margin)
    Cost = Retail x (1-margin)
    Margin = (Retail - Cost) / Retail

  3. #3
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: simple - if x then x calculation

    I think you mean (retail-cost)/retail = margin, don't you?

    A bit of algebra therefore tells you that Cost = Retail - (Retail x Margin)

    You should be able to work it out now!
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  4. #4
    Registered User
    Join Date
    10-19-2012
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: simple - if x then x calculation

    correct - I have it currently as: (retail-cost)/retail = margin

    What formula can I use to determine what the retail would be if the margin was 50% ?

  5. #5
    Registered User
    Join Date
    08-08-2007
    Location
    Vancouver
    MS-Off Ver
    Excel 2002, Excel 2007, Excel for Mac 2011
    Posts
    38

    Re: simple - if x then x calculation

    Please Login or Register  to view this content.
    You don't need an if then formula.

    For example...
    A1 = Cost
    A2 = Marign
    A3 has this formula below... which calculated your retail price

    Please Login or Register  to view this content.
    Last edited by ychartra01; 07-05-2013 at 01:56 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1