12 Replies Latest reply on Jul 12, 2016 5:58 AM by Xianan Zhao

    Conditional Field

    Xianan Zhao

      Hi guys,

       

      First thank you for your time to read my post. This question bugs me for awhile. I would like to add a conditional field on the workbook depending on the sales number by month.

       

      Here are the conditions,

      if a customer's sales in July(current month) is zero or null, then it shows 'Has Not Bought'.

      If a customer's sales in July(current month) is less than the sales in June (previous month), then it shows 'Down 1 Month'.

      If a customer's sales in July(current month) is less than June and May (previous 2 months), then it shows 'Down 2 months'.

      Else show 'Good'

       

      It may look like this Excel:

      See attachment for sample workbook

       

       

      Thanks for help,

       

      Sherman