View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
talltom talltom is offline
external usenet poster
 
Posts: 22
Default IF, AND, OR Function

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.