Formula help = if date contains NA then show NA in the target cell

Ibrahim Khalaf

Hello

im working on sheet managing calibration task , i have 4 columns as following :

1- calibration frequency

2- last calibration

3- next calibration

4 -calibration status

what i need a formula in the 4th column calibration status based on date done, over due and NA , i have complete the easy part of formula for done and over due, the problem is i need to say if cell blank or contain NA the NA

this is formula i have done

=IF([Next P/M]@row >= TODAY(), "P/M Done", IF([Next P/M]@row < TODAY(), "P/M Overdue",IF([Next P/M]@row=NA."NA")))

and it dosnt work for NA it shows #INVALID OPRATION

I hope that my question is clear

Dan W

Looks like you need a good ole ISBLANK

=IF(ISBLANK([Next P/M]@row), "N/A", IF([Next P/M]@row >= TODAY(), "P/M Done", IF([Next P/M]@row < TODAY(), "P/M Overdue")))

Dan W

Looks like you need a good ole ISBLANK

=IF(ISBLANK([Next P/M]@row), "N/A", IF([Next P/M]@row >= TODAY(), "P/M Done", IF([Next P/M]@row < TODAY(), "P/M Overdue")))

Ibrahim Khalaf

thanks Dan

it works good

thanks again

Dan W

Happy to help!