| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 27320 | 2002-11-19 23:11:00 | Excel Question regarding GST | Chilling_Silence (9) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 99738 | 2002-11-19 23:11:00 | I've got a column being added up, and then I want to add GST to the cell underneath, so it;s like this: =SUM(C2:C14) is in C15 and then in C16 I want C15 + 12.5% How would I do that? Cheers Chilling_Silence |
Chilling_Silence (9) | ||
| 99739 | 2002-11-19 23:13:00 | just type in c16 the equation =c15*1.125 | jeep (1673) | ||
| 99740 | 2002-11-19 23:25:00 | I knew it was something easy, Thanks! | Chilling_Silence (9) | ||
| 99741 | 2002-11-20 01:17:00 | Hmmm..... GST whats that (its all yours isn't it!) ;) | Dolby Digital (160) | ||
| 99742 | 2002-11-20 05:05:00 | or =c15*(12.5%) |
veterannz (960) | ||
| 99743 | 2002-11-20 08:30:00 | or =c15*(12.5%) Actually that won't work. If c15=100 then your formula returns 12.5 or =c15*(12.5%)+c15 would work though. :-) =c15*1.125 is the way I do it. |
Elephant (599) | ||
| 99744 | 2002-11-20 08:34:00 | =Round(c15*1.125,2) better still: =Round(c15*(1+GST),2) where GST is a named range with .125 in it so you can change the rate when required. need to round to two decimal places to ensure no nasty surprises if things don't add later. robo. |
robo (205) | ||
| 99745 | 2002-11-20 08:57:00 | In c16 enter =sum(c15/8+c15) if you want add the gst to a total divide by 8 if you want to remove the gst from a total divide by 9 hope this helps. |
kirrie kiwi (279) | ||
| 1 | |||||