Thread: IF, OR HELP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
talltom talltom is offline
external usenet poster
 
Posts: 22
Default 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