| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Discounting from a table of values
I am struggling to return a value in a formulae,
Heres my example 155 needs to return 2.50% and 555 would be 7.50% 1 50 0.00% 51 250 2.50% 251 500 5.00% 501 1,000 7.50% 1,001 2,500 10.00% 2,501 5,000 12.50% 5,001 10,000 15.00% I have tried multiple =if( but am failing badly Thx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Idenifying and Listing Duplicate Values in a Table? | Excel Discussion (Misc queries) | |||
| Referencing a specific number to more general values in a table. | Excel Worksheet Functions | |||
| Sorting values in a bar chart | Charts and Charting in Excel | |||
| Creating a chart from a table of values | Charts and Charting in Excel | |||
| Pivot Table Help With Market Values | Excel Discussion (Misc queries) | |||
Threaded Mode
