Multiple If statements in Excel 2000?

Question

I am working on an Excel spreadsheet that I need to have multiple questions answered. I need one statement to answer three questions. An example is as follows: If cell Q3>0,Q3,"OK"( that is the simple part) if Q3="","","No Data". I wrote the formula as follows: If(Q3>0,Q3,"OK", IF(Q3="","",Q3)). The result either needs to be "OK', "No Data" or Q3 but I get an error message telling me that my formula is wrong and I need to eliminate a = of add a ). But I am not sure of where it needs to be added or removed. If someone can email me I will be glad to send them a line from my spreadsheet so I can get this issue resolved.

Answer 1

yep there's a problem with your IF stmt.  Just change it

=IF(AQ3>0, Q3, IF(Q3="", "No Data", "OK"))

this will give the result of

if Q3>0 , then show Q3

if Q3="", then show No Data

otherwise if above 2 conditions are not met, then show OK

the basic syntax of the IF stmt is

if something, do something, else do something else

so when nesting IF stmts, keep in mind that your "Else do something" part needs to be your next IF stmt.

you have IF(Q3>0, Q3, OK...."

the "ok" is the "else" part.  Instead it needs to be the next IF stmt.

Answer 2

use this function

=LOOKUP({B1,b2,b3} res1,res2,res3)

check help for more explananation.

Answer 3

I think you've typed too much Data_Value in your formula.

Because the basic formula of logical test function IF is only made one Data for one Logical Test. You can make two Data Values only for single IF function.

This is the basic formula: IF(logical_test,value_if_true,value_if_f...

When you use multiple IF function you should use two Data Values only for the last Logical Test.

So your formula should be:

=If(Q3>0,Q3,If(Q3="","No Data","OK")).