Jun 08 2021 09:22 AM
Jun 08 2021 09:30 AM
Jun 08 2021 10:05 AM
Jun 08 2021 10:27 AM
@SandeepDaga See attached. This is what I get.
Row 2: B is not greater than A (in other words, B-A is not greater than zero) and both are not equal to NA, thus the result is FALSE
Row 3: No problem, both are NA, thus TRUE
Row 4: On what basis do you want to see a blank here? That not in your original question. "Anything else should show FALSE". Any two texts not both equal to NA will result in FALSE.
Row 5: B is not greater than A, thus FALSE
Row 6: Sames as row 4; No numbers involved here and the texts are not both NA, thus FALSE.
Jun 08 2021 10:43 AM