Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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),IF(B$23*$M$2*0.12525, B$23*$M$2*0.12525,IF($M$2=0,0,25)))) Tyro 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, AND, OR Function
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |