IF, AND, OR Function

[talltom]

Hi everyone,
The following is a formula that works in Quattro Pro. I am trying to
convert it to Excel 2003.

@INT(@IF($F$3="A"#OR#$F$3="PL"#OR#$F$3="PPL"#AND#(B$23*$M$2*0.125)>25,B$23*$M$2*0.125,@IF((B$23*$M$2*0.0125)>25,B$23*$M$2*0.0125,@IF($M$2=0,0,25))))

I am having trouble combining IF, OR, and AND in the same statement. Any
help would be appreciated. Thanks in advance.

 

[Pete_UK]

Try this:

=INT(IF(AND(OR($F$3="A",$F$3="PL",$F$3="PPL"),B$23*$M$2*0.125>25), B
$23*$M$2*0.125,IF(B$23*$M$2*0.0125>25,B$23*$M$2*0.0125,IF($M
$2=0,0,25))))

I think this maintains the same logic.

Hope this helps.

Pete

 

[Tyro]

Try this:

=INT(IF(AND(OR($F$3="A",$F$3="PL",$F$3
="PPL"),B$23*$M$2*0.125>25),IF(B$23*$M$2*0.125>25,B$23*$M$2*0.125>25,IF($M$2=0,0,25))))

Tyro

 

[talltom]

Thank You Pete_UK. It works great!!!

Try this:

=INT(IF(AND(OR($F$3="A",$F$3="PL",$F$3="PPL"),B$23*$M$2*0.125>25), B
$23*$M$2*0.125,IF(B$23*$M$2*0.0125>25,B$23*$M$2*0.0125,IF($M
$2=0,0,25))))

I think this maintains the same logic.

Hope this helps.

Pete