| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex formulae??????????? Excel 2003
Col F contains a purchase amount including a GST tax, col G contains the same
purchase amount excluding GST. Col K is sale price inc GST, col L excluding GST. When ever the value in L is than that of G, I need to calculate the difference between the two amounts of tax, ($2000 at purchase & $19090.91 at sale, being $90.91) I then need to show this figure in col I as well as adding it into col H. F G H I K L $22000.00 $20000.00 $861.91 $90.91 $21000.00 $19090.91 Cheers from frustrated excel novice, Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to solve a complex problem using Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 - Toggle formulae display ON/OFF on worksheet | Excel Discussion (Misc queries) | |||
| Ruby access to an existing Spreadsheet with complex formulae | Excel Discussion (Misc queries) | |||
| Where to find complex matrix math add-ins for Excel 2003? | Excel Worksheet Functions | |||
| EXCEL 2003 formulae | Excel Discussion (Misc queries) | |||
Threaded Mode
