Assuming that the tax operates as follows:
Net price AUD$100
PSt @ 8% = AUD$8
GST @ 5% = AUD$5
Hi. building a spreadsheet and have gotten stumped. I have the total price in cell f6. In cell C6 I need price with no taxes. D6 should be the pst of 8% and E6 should be the gst of 5%. I realize this is working backwards and that is why it is stumping me so badly. Your help would be so great appreciated, been trying for hours! Thank you so much!
You may want to round two of the formulas and plug the third calculation.
Tip: To avoid chasing code always use Option Explicit.
There are currently 1 users browsing this thread. (0 members and 1 guests)