ExcelBanter - IF, AND, OR Function

You're welcome, Tom - thanks for feeding back.

Pete

On Jan 9, 5:47*pm, talltom wrote:
Thank You Pete_UK. *It works great!!!

"Pete_UK" wrote:
Try this:

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

I think this maintains the same logic.

Hope this helps.

Pete

On Jan 9, 5:18 pm, talltom wrote:
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.- Hide quoted text -

- Show quoted text -