Nested IF

[mikegauntlett]

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

[sunny_talwar]

May be try with Len(Trim())

=If(Len(Trim(Status)) = 0,

  If(Len(Trim(AARO_Booking_Period)) = 0, 'R0', 'R1'), Status)

[mikegauntlett]

Fraid not R0 is still not getting produced, i have checked the data and there are actual cases where R0 should be.

[sunny_talwar]

Would you be able to share some raw data to test this out?