5 Replies Latest reply on Sep 12, 2012 4:20 PM by Tracy Rodgers

    Multiple if conditions between the sheets

    Michael Sonu

      Hi,

       

      I have two database:

       

      1) Pipeline

      2) Sales

       

      Basically, I want to calculate the current month sales with below criteria.

       

       

      If the order numer is repeated more than once ; I  want to consider the latest one.( Type with latest date).

       

      for ex: MCQ154- repeated twice ( delivery & return ); i need  0  for delivery and 1 for Return (because return has the latest date).

       

      The status is from the Pipeline database for each order #.

       

      If my latest sales type is delivery & the status from pipliene is Stock then1

      If my latest sales type is return & the status from pipliene is sold then-1

      If my latest sales type is return & the status from pipliene is stock then 0.

      If it is not my latest type for the order then 0

       

       

       

      sample.png

        I have attached the sample work book with the result manually adjusted. I want to do the same with a formula.

       

      Your help is very much appreciated.

       

      Michael.