| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a multiple condition formula?
I have 12 different conditions where I need to assign a number:
If E6 < 36.9, then the number is 0 If E6 =37 and <=37.49 then number is 0.25 If E6 =37.5 and <=37.99 then number is 0.50 E6 =38 and <= 38.49 then number is .75 and so on.... A friend told me that Excel will not let you use more than 7 conditions. Is this true? If someone could send me the formula to set up these conditions I would be greatly appreciative as I have worn out the help tool! Thanks! Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple if condition formula required | Excel Discussion (Misc queries) | |||
| Multiple Scenario Condition Formula | Excel Worksheet Functions | |||
| What formula/fn would I use to count multiple condition records? | Excel Worksheet Functions | |||
| Multiple Condition Formula | Excel Worksheet Functions | |||
| Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Threaded Mode
