| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 38475 | 2003-10-08 07:19:00 | excel function | Trev O (452) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 181366 | 2003-10-08 18:07:00 | The best solution is to get some proper software from someone like www.acclaim.co.nz. It has appeared on the PCW cd. It's free for personal use and not very expensive for business. It will do a better job than excel. | wotz (335) | ||
| 181367 | 2003-10-08 18:55:00 | Morning all, thanks Wots for the drop down menu idea for column B, which was going to be my second question... I did that last night via Insert--Name and Data--Validation. I don't want to go to other software as they're so complicated for what I want (or at least I find them complicated!) I thought about the If function some more Parry and that could work, apart from, sometimes I split the petrol money to 2 columns and also when I buy stuff from (say) Mitre10 it could go into about 5 boxes, eg house R&M, Garden R&M, Car R&M etc. sorry I couldn't see your example page (not available) Godfather in columns c-g I have my income, also GST divided and and in c H I have the whole amount from both sides added up to give a monthly result at the bottom (all the columns have a monthly result at the bottom). reversing the whole spreadsheet info sound good, but how would I end up with each items GST free amount in the box I type into? |
Trev O (452) | ||
| 181368 | 2003-10-08 19:32:00 | AAh, well my suggestion wouldn't work. I use an even simpler method however. MYOB. Took 5 minutes to do my 6 monthly GST return this month. At FYI I simply burn the file to a CD and give it to my Accountant. |
godfather (25) | ||
| 181369 | 2003-10-09 00:52:00 | Aah, but i'm saving my hard earned dolleros for me, so I don't have that expensive accountant anymore and it only takes me five minuits to do my 6 monthly GST returns and five mins for the IR3's too and I also burn it all to CD... so is there no way I can type a figure into a box and after pressing enter it turn into the 8, nineths? |
Trev O (452) | ||
| 181370 | 2003-10-09 04:25:00 | Hi again, yes typing into a box then clicking a button could put the amount into a cell but it has its own problems with where to put the data as it changes for you. There could be a simple box to enter amount, list boxes to choose the column & row to input it to etc but if your objective is to save time then I dont think this will speed things up much as its a lot quicker just to have extra columns for the expenses and in these have your formula to calc the ex-gst amount eg =(b1/8)*9 or b1/1.125 where b1 is the cell where you entered the incl gst amount. You could do what you want with code as well which may be quicker if you dont want to use new columns. But again there are issues depending upon how you approach it as you need to distinguish between which cells are OK (have the exgst amt) and those that dont. |
parry (27) | ||
| 181371 | 2003-10-09 05:43:00 | so it's a no goer then? I'll do the IF function as you suggested for just the sure bets, eg phone, power, rates etc. and type the other variable box amounts manually like I'm doing now.. I'll be a bit better off so It'll be worth it, thanks Parry Thanks everyone for the help also Trev |
Trev O (452) | ||
| 1 2 | |||||