Using If and Iferror together

JR SEW

I am stuck, I have the two following fx that work independently but I can not seem to get them to work together. they are for a column that displays duration based on a due date in a different column plus a service interval.

This one if for if the result is a Neg number

=IF([Due Date]@row - TODAY() < 0, "Calibration EXPIRED", [Due Date]@row - TODAY())

But I ran into an error if there is not a due date available so i wrote

=IFERROR([Due Date]@row - TODAY(), "No Due Date")

I am sure is the formating, but I have run out of combinations to try.

=IFERROR(IF([Due Date]@row - TODAY() < 0, "Calibration EXPIRED", [Due Date]@row - TODAY(), [Due Date]@row - TODAY(), "No Due Date"))

Produces #INCORRECT ARGUMENT SET

=IFERROR(IF([Due Date]@row - TODAY() < 0, "Calibration EXPIRED", [Due Date]@row - TODAY()), Due Date]@row - TODAY(), "No Due Date")

Produces #UNPARSEABLE

Carson Penticuff

This should do it… you were close.

=IFERROR(IF([Due Date]@row - TODAY() < 0, "Calibration EXPIRED", [Due Date]@row - TODAY()), "No Due Date")

Carson Penticuff

This should do it… you were close.

=IFERROR(IF([Due Date]@row - TODAY() < 0, "Calibration EXPIRED", [Due Date]@row - TODAY()), "No Due Date")