| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated If Equation
I have figured out the following formula -
=(IF(K16="1 of 4",IF(I1660,"0",(IF(I16<11,"2",IF(I1610,"1","2") ))),0)) and it works exactly as i want it. The point here is that if K16 - "1 of 4" then the formula goes from there. I want to be able to include a total of three possible TRUE responses: "1 of 4" "5 of 10" and "25%" How can i complete this formula to include the additional 2 TRUE options? Thank you! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Complicated If Equation
You can use the OR function to add the other scenarios. =(IF(OR(K16="1 of 4",K16="5 of 10",K16=0.25),IF(I1660,"0",(IF(I16<11,"2",IF(I16 10,"1","2") ))),0)) Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=515508 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
| Need Help with #N/A in equation | Excel Discussion (Misc queries) | |||
| Averaging/Rounding Equation Problem | Excel Worksheet Functions | |||
| Averaging/Rounding Equation problem | Excel Discussion (Misc queries) | |||
| Logarithmic Trendline Equation | Charts and Charting in Excel | |||
Linear Mode
