IF, AND, OR Function

  • Thread starter Thread starter talltom
  • Start date Start date
T

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.
 
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
 
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
 
Thank You Pete_UK. It works great!!!

Pete_UK said:
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
Click to expand...
 
Back
Top