Forum Discussion
Request for Experts Formulas for this Calculation
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 ...
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.
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.
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.