asked on

I need help with Excel function interpretations

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

SOLUTION

Phillip Burton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Phillip Burton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Phillip Burton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Phillip Burton

Surely you can work out the rest yourself, as they are the same as the above.

BILL Carlisle

ASKER

=SUMIF('Various Adj'!$F$5:$F$500,A134,'Various Adj'!$K$5:$K$500)
For each cell in 'Various Adj'!$F$5:$F$500
If it is equal to A134
then add the corresponding cell in column K.

Open in new window

"Various Adj" is another tab
so "For each cell in Various Adj'!$F$5:$F$500"

so how do I break this apart?
!$F$5:$F$500

SOLUTION

Phillip Burton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

BILL Carlisle

ASKER

Great.. I'm seeing it.. will get back to you..

thank you!
Bill

ASKER CERTIFIED SOLUTION