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.
|