5 Replies Latest reply on Feb 22, 2013 7:02 AM by donald nguyen

    Need help on spotlighting calculation

    donald nguyen

      Hello

      I have a worksheet below and I would like to set up the color code as the following:

           IF OT% >= 99.30% THEN "OT's PASS"

            IF OD% <= 0.50% THEN "OD's PASS"

           IF XE% <= 0.35% THEN "XE's PASS"

            IF DOL <= 0.00 THEN "DOL's PASS"

                ELSE "FAILS"

      Could someone help me to create the calculation field please

      Thanks

      DeliveryQuality (weekly).jpg