If Cell Blank Return "N/A"

JNorman

If Date of Calibration is blank, return N/A instead of DUE.

=IF([Calibration Due]@row - TODAY() > 90, "GOOD", IF([Calibration Due]@row - TODAY() > 30, "3 MONTHS", IF([Calibration Due]@row - TODAY() > 0, "1 MONTH", "DUE")))

Anjanesh Vaidya

Hi JNorman,

You can try the following formula to achieve the required output.

I hope it will work.🙂

=IF([Calibration Due]@row - TODAY() > 90, "GOOD", IF([Calibration Due]@row - TODAY() > 30, "3 MONTHS", IF([Calibration Due]@row - TODAY() > 0, "1 MONTH", IF(ISBLANK([Calibration Due]@row), "N/A", "DUE"))))

Anjanesh Vaidya

Hi JNorman,

You can try the following formula to achieve the required output.

I hope it will work.🙂

=IF([Calibration Due]@row - TODAY() > 90, "GOOD", IF([Calibration Due]@row - TODAY() > 30, "3 MONTHS", IF([Calibration Due]@row - TODAY() > 0, "1 MONTH", IF(ISBLANK([Calibration Due]@row), "N/A", "DUE"))))

JNorman

Solved, thanks Anjanesh 👍

Anjanesh Vaidya

Happy to help!👍️ 😀 JNorman