3 Replies Latest reply: Mar 22, 2017 6:06 AM by Kshitija Shinde RSS

    IF condition!

    Kshitija Shinde

      Hi everyone,

       

      Is my below if condition proper?

      I think m doing some mistake in 'and'!

      Can anyone correct this condition?

       

       

      IF(date1- date2 <= 30, 'Less Than 30',

      IF(date1- date2 > 30 AND date1- date2 <= 45, 'Grace period',

      if((date1- date2 >45,'Outside grace period'))) as Range_values ;

       

      Thanks& Regards,