View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default IF, AND, OR Function

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.