Dividing a markup

1. 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. Hi,

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)

3. 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

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

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