+ Reply to Thread
Results 1 to 3 of 3

Dividing a markup

  1. #1
    Registered User
    Join Date
    12-19-2006
    Posts
    5

    Dividing a markup

    I have a formula which computes a selling price

    =IF(L8=0,"",(L8*M8/100*1.12+G8+I8+K8)/N8+O8)

    n8 = my markup

    so if i have 20% in n8 i want it to divide by .80
    of if have 25% in n8 i want it to divide by .75

    how can i do this?

  2. #2
    Registered User
    Join Date
    09-20-2006
    Location
    Poland
    Posts
    46
    Hi,

    Quote Originally Posted by gtapper
    =IF(L8=0,"",(L8*M8/100*1.12+G8+I8+K8)/N8+O8)
    n8 = my markup
    so if i have 20% in n8 i want it to divide by .80
    of if have 25% in n8 i want it to divide by .75
    how can i do this?
    I am not sure if this is what you mean (becase of "+O8" component), but try:

    =IF(L8=0,"",(L8*M8/100*1.12+G8+I8+K8)/(1-N8)+O8)
    MS Excel Games Library and much more:
    http://www.dzikosoft.com/gmexcel

  3. #3
    Registered User
    Join Date
    12-19-2006
    Posts
    5
    no luck

    the +O8 is that i'm adding in freight after the markup

    so i'm computing my entire cost with a markup then adding in freight after

    but since we do marginal markups i dont know how to make the right formula

+ 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