3 Replies Latest reply: Jan 23, 2018 11:42 AM by Sunny Talwar RSS

    Nested IF

    Michael Gauntlett

      Hi I have the below

       

      =IF(IsNull(Status),(IF(IsNull(AARO_Booking_Period),'R0','R1')),Status)

       

      The R1 gets produced but the R0 is failing.

       

      I am attempting to say

       

      Anything where both the status and the Aaro Booking period are null = R0

      where only the the status is null = R1

      all others = Status

       

      Any Ideas