Good Afternoon,
I had previous pricelist that I have fululas set up to adjust pricing with %markup & gst 10% asper below
H5 (destination cell) =(I5+I5*$AO$4+$AO$7)*(1+$AO$5)
I5 is the original starting price $788.00
AO4 is 10% gst
AO7 is a labour rate $300.00
AO5 is 30% markup rate
In total equals $1517 (with rounding)
I now want it to be as follows.
I5 $788.00 + AO7 $300 with a mark-up of 30% in cell AO5 and then adding on gst at the end of 10% in AO4
total should be $1555.84
Thanks for your help
I had previous pricelist that I have fululas set up to adjust pricing with %markup & gst 10% asper below
H5 (destination cell) =(I5+I5*$AO$4+$AO$7)*(1+$AO$5)
I5 is the original starting price $788.00
AO4 is 10% gst
AO7 is a labour rate $300.00
AO5 is 30% markup rate
In total equals $1517 (with rounding)
I now want it to be as follows.
I5 $788.00 + AO7 $300 with a mark-up of 30% in cell AO5 and then adding on gst at the end of 10% in AO4
total should be $1555.84
Thanks for your help
Centurion Retail Pricelist_July_2022.xls | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | |||
1 | Michael Andrew Clark T/as JaMac Garage Doors Sectional Overhead Door - Colorbond Finish-WoodGrain Price List Including GST - Supply & Install Effective From 1 July 2022 | ||||||||||||||||||||||||||||||||||
2 | Note: The prices list here in are based on door size not opening size. We recommend the following door ovelaps for Sectional Doors. Width: 35mm per side and Height: 10mm | ||||||||||||||||||||||||||||||||||
Sheet2 |