Complicated If Equation

's Computer Specifications

I have figured out the following formula -

=(IF(K16="1 of 4",IF(I16>60,"0",(IF(I16<11,"2",IF(I16>10,"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!

's Computer Specifications

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(I16>60,"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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Very complicated report to go with a very complicated query....HEL	ReportTrouble	Microsoft Access Reports	1	14th Apr 2009 02:02 PM
complicated equation fields	grammatim	Microsoft Word Document Management	2	3rd Mar 2009 01:36 PM
How to convert Math type equation 5 to word 2007 equation	=?Utf-8?B?ZmJyaW9s?=	Microsoft Word Document Management	6	12th Sep 2006 10:08 PM
Equation Editor - Word 2003 - Equation alignment	=?Utf-8?B?aGVpbmFsZW0=?=	Microsoft Word Document Management	1	25th Aug 2006 12:48 PM
Equation Editor- problem when editing an equation	=?Utf-8?B?R2FieSBMLg==?=	Microsoft Excel Misc	0	27th Sep 2005 09:24 PM