| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation with IF functions
I have a series of data on production volumes (below). We pay a bonus of min
£50 for upto 500 units of production and then £0.12 per unit above that. I want to calculate the bonus so it is just a single figure in £s in the column next to Prod. Any ideas how to do this? Prod Bonus 275 50 350 50 510 50 + 1.2 = 51.2 600 50 + 12 = 62 Thanks in advance -- daedalus1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| Quick date calculation functions | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Threaded Mode
