| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
URGENT - Where do i start!
Try...
=LOOKUP(L14,{0,3000,4000,5000},{0,50,75,100}) Adjust the brackets and bonus amounts accordingly. Hope this helps! In article om, wrote: I have untill about 10am sydney time on the 28th Nov... I have a number that when within a certain bracket needs to generate the corresponding bonus ammount if a consultant makes between $3000 and $3999 then the bonus is $50 If a consultant makes between $4000 and $4999 then the bonus is $75 and so on i need a formula to do that automatically the bonus value ammount is in L16 so that would be where the formula is and the total monthly sales is in L14 PLEASE HELP I only have 9 hrs |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Start spreadsheet with WinXP start | Excel Worksheet Functions | |||
| Help! Excel 2000 fully SP'ed will not start | Excel Discussion (Misc queries) | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
| Urgent Urgent Urgent!!! | Excel Discussion (Misc queries) | |||
| Inserting Blank Rows Macro? | Excel Worksheet Functions | |||
Threaded Mode
