| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to make a mark up table with more than 7 if statements
=IF(A3<4.99,A3*6,IF(A3<9.9,(A3*6.3)+5,IF(A3<24.99, (A3*6)+15,IF(A3<49.99,(A3*5.8)+12,IF(A3<74.99,(A3* 5.5)+8,IF(A3<99.99,(A3*5.25)+8,IF(A3<149.99,(A3*5. 25)+8)))))))
this is the formula so far but i need more than 7 statements is there a way to put more than 7? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling from a table to make a timeline | Excel Worksheet Functions | |||
| Make Excel Table fit into Word Doucument | New Users to Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| i need to make a pub quiz league fixture table | Excel Discussion (Misc queries) | |||
| how do I make hard carriage return appear in pivot table? | Excel Discussion (Misc queries) | |||
Threaded Mode
