IF function

[terimusic]

what is the general form of the IF function

 

[hedrijw]

IF(logical_test,value_if_true,value_if_false)

You can look this up in Help!

 

[attc]

=IF(NOT(FIND(answer,HELP)),"try mrexcel.com","try HELP first")


This message was edited by attc on 2002-11-06 09:36

 

[MarkVMcCullagh]

=if(Condition,Result for meeting the condition, Result for not meeting the condition)

For example =if(4>3,"Larger","Not Larger")will display the result Larger in the cell

 

[DonkeyOte]

and one last thing...

combining IFs with IFs, ANDs and ORs

You can embed 7 IFs

=if(a=a,1,if(b=b,2,etc...

You can combine AND statements - therefore having 2 tests as opposed to the normal one

=if(And(a1=1,b1=2),"if both are true","if one or both are false)

and similarly with OR

=if(or(a1=1,b1=2),"if one is true","if both are false)