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?
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?
Hi,
I am not sure if this is what you mean (becase of "+O8" component), but try:Originally Posted by gtapper
=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
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)
Bookmarks