Request for Experts Formulas for this Calculation

Copper Contributor
Currency SGD                 Less 15% of TotalTotal with 3% GSTTotal
Singapore Dollars9.0010.3010.05
Singapore Dollars4.305.205.00
Singapore Dollars4.305.205.00
Singapore Dollars5.106.206.00
Singapore Dollars8.4010.209.90
Singapore Dollars4.205.004.90
Singapore Dollars10.2012.4012.00

 

Let say If I only have data on the Total amount, how do I go about entering the formula for Less 15% of Total and Total with 3% GST?

 

Kindly help me, thks!

3 Replies

@Superhero3984 

I tried to build a formula that went from your Total column to each of the other two, but the results were inconsistent. The closest I got was to assume amounts should be rounded to the nearest 5 cents.

 

The following formula assumes your sample data are in A2:D2. Values in D2 are given. The formulas for B2 and C2 (less 15% discount and plus 3% GST) are shown below:

=MROUND(D2*0.85,0.05)
=MROUND(D2*1.03,0.05)
Thank you Sir,
It do help in some way. However, I required to derive to a nearest 0.10 cent if its above 0.5 should be 1.0 then.

@Superhero3984 

The figures in your example table neither round up to the dollar nor to 10 cents. So I don't understand how to interpret "I required to derive to a nearest 0.10 cent if its above 0.5 should be 1.0 then."

 

Either revise your example table, or clarify how you want the calculations to be done.