Hi All,

I need help with Excel function interpretations:

This is my interpretation of this one: =IF(AND(OR(ISBLANK(K8),K8<>0),J8=0,B8=0),K8,0)

if (ISBLANK(K8) OR K8<>0) AND J8=0 ???? then

K8

else

0

end if;

This is my interpretation of this one: =IF(W60=0,IF(OR(P60<0,O60<0),P60,0),0)

if W60=0 then

IF(P60<0 OR O60<0)then

P60

else

0

end if

else

0

end if

=SUMIF('Various Adj'!$F$5:$F$500,A134,'Various Adj'!$K$5:$K$500)

=IF(AND(D134<>0,J134=0),P134,0)

=SUMIFS(FGI!$L$2:$L$20000,FGI!$A$2:$A$20000,A134,FGI!$G$2:$G$20000,"FGI")

=ROUND(SUMIF('SO Backlog'!$D$2:$D$7947,A134,'SO Backlog'!$K$2:$K$7947),0)

=IF(ISERROR(+H134/B134),0,+H134/B134)

=SUMIFS(Rev!$V$2:$V$3000,Rev!$AO$2:$AO$3000,A8,Rev!$W$2:$W$3000,"REV")

Thank you for your help,

Bill

=ROUND(SUMIF('SO Backlog'!$D$2:$D$7947,A134

SUMIF is explained above; this will ROUND the result of the SUMIF to zero decimals, syntax is:

=ROUND(Formula,Decimals)

=IF(ISERROR(+H134/B134),0,

This is looking at the formula "H134 divided by B134", if the result is an error then put zero else put result. Depending on version of excel (2007 or later) you can use the following:

=IFERROR(H134/B134,0)

Syntax is:

=IFERROR(Formula, Error_Result)

Thanks

Rob H