Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, OR HELP
The following is a fully working formula in Quattro Pro.
My challenge is to convert this to a MS Excel 2003 working formula. I have each section of the formula working in its own cell, but I cannot get them to work nested. The answer to "PB" and "B" is 242, and the answer to "A" and "MG" is 264, and the answer to the INT is 24 @IF($J$8="N",@IF($F$3="B"#OR#$F$3="PB",(B$19/100)*$D$132,@IF($F$3="A"#OR#$F$3="MG",((B$19/100)*$D$132)+$D$133,@INT(@IF(B$19<1000,$D$132,B$19 *$D$134)))),0) talltom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, OR HELP
Change the first @ to =.
Remove all remaining @. The #OR# operator is not infix in Excel, it has a functional form. I.e.: IF($F$3="A"#OR#$F$3="MG", becomes: IF(OR($F$3="A",$F$3="MG", HTH Kostis Vezerides Ï/Ç talltom Ýãñáøå: The following is a fully working formula in Quattro Pro. My challenge is to convert this to a MS Excel 2003 working formula. I have each section of the formula working in its own cell, but I cannot get them to work nested. The answer to "PB" and "B" is 242, and the answer to "A" and "MG" is 264, and the answer to the INT is 24 @IF($J$8="N",@IF($F$3="B"#OR#$F$3="PB",(B$19/100)*$D$132,@IF($F$3="A"#OR#$F$3="MG",((B$19/100)*$D$132)+$D$133,@INT(@IF(B$19<1000,$D$132,B$19 *$D$134)))),0) talltom |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, OR HELP
=IF($J$8="N",IF(OR($F$3="B",$F$3="PB"),(B$19/100)*$D$132,IF(OR($F$3="A",$F$3="MG"),((B$19/100)*$D$132)+$D$133,INT(IF(B$19<1000,$D$132,B$19*$ D$134)))),0)
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "talltom" wrote in message ... The following is a fully working formula in Quattro Pro. My challenge is to convert this to a MS Excel 2003 working formula. I have each section of the formula working in its own cell, but I cannot get them to work nested. The answer to "PB" and "B" is 242, and the answer to "A" and "MG" is 264, and the answer to the INT is 24 @IF($J$8="N",@IF($F$3="B"#OR#$F$3="PB",(B$19/100)*$D$132,@IF($F$3="A"#OR#$F$3="MG",((B$19/100)*$D$132)+$D$133,@INT(@IF(B$19<1000,$D$132,B$19 *$D$134)))),0) talltom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|