| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 107844 | 2010-03-03 20:36:00 | EXCEL question | prefect (6291) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 863732 | 2010-03-03 20:36:00 | Could some one help please with a formula to change a total cost which includes gst to a total with gst excluded. Could do it in 2 formulas I suppose divide by 9 then subtract from total can it be done in one formula? Thanks |
prefect (6291) | ||
| 863733 | 2010-03-03 21:06:00 | 11.25 =A1-(A1/9) (result = "10") (where the value "11.25" is in cell A1) |
johcar (6283) | ||
| 863734 | 2010-03-03 21:26:00 | Correct answer. A1/9 is evaluated first then subtracted from the original A1. |
Sweep (90) | ||
| 863735 | 2010-03-03 21:33:00 | Thanks johcar worked like a treat. Doing a spreadsheet for a mate who has a franchise saw him with calculator and paper will take him days. By entering in xcel sheet should take an hour at most The franchise has a 3month period for every 1000 excl gst you spend with him goes into 4 prizes to go to Gt Barrier reef with top Oz fisherman. His report on cashbook has gst price and needs to enter invoice numbers which have to be printed and sent as proof to franchise hq. |
prefect (6291) | ||
| 863736 | 2010-03-03 21:43:00 | Could some one help please with a formula to change a total cost which includes gst to a total with gst excluded. Could do it in 2 formulas I suppose divide by 9 then subtract from total can it be done in one formula? Thanks Column A is the number you need to change Column B is the formula, which is =SUM(A1/9)*8 If you enter A1 as 11.25, the result in B1 will be 10.00 If you enter A2 as 112.50, the result in B2 will be 100.00 Note as you drag the formula in B1 down, it automatically changes A1 to A2 etc) Cheers |
WalOne (4202) | ||
| 863737 | 2010-03-03 23:10:00 | Thanks johcar worked like a treat. Doing a spreadsheet for a mate who has a franchise saw him with calculator and paper will take him days. By entering in xcel sheet should take an hour at most The franchise has a 3month period for every 1000 excl gst you spend with him goes into 4 prizes to go to Gt Barrier reef with top Oz fisherman. His report on cashbook has gst price and needs to enter invoice numbers which have to be printed and sent as proof to franchise hq. Would be more than happy to accompany a prizewinner in recompense for my suggestion... :D :p |
johcar (6283) | ||
| 863738 | 2010-03-03 23:14:00 | Would be more than happy to accompany a prizewinner in recompense for my suggestion... :D :p I'm all for that. And as mine is the most unwieldy of the replies, naturally I would have first right of refusal. :p |
WalOne (4202) | ||
| 863739 | 2010-03-04 00:11:00 | Naturally!! :D | johcar (6283) | ||
| 863740 | 2010-03-04 01:06:00 | 11.25 =A1-(A1/9) (result = "10") (where the value "11.25" is in cell A1) Just a small question why 11.25 when gestapo is 12.5% remember you are talking to a thicky here. |
prefect (6291) | ||
| 863741 | 2010-03-04 01:32:00 | 12.5% of 10 = 1.25 10+1.25 = 11.25 |
AvonBill (11358) | ||
| 1 2 | |||||