Jul 16 2019 06:08 PM
Currency SGD | Less 15% of Total | Total with 3% GST | Total |
Singapore Dollars | 9.00 | 10.30 | 10.05 |
Singapore Dollars | 4.30 | 5.20 | 5.00 |
Singapore Dollars | 4.30 | 5.20 | 5.00 |
Singapore Dollars | 5.10 | 6.20 | 6.00 |
Singapore Dollars | 8.40 | 10.20 | 9.90 |
Singapore Dollars | 4.20 | 5.00 | 4.90 |
Singapore Dollars | 10.20 | 12.40 | 12.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!
Jul 16 2019 09:19 PM
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)
Jul 21 2019 07:23 PM
Jul 21 2019 07:37 PM
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.