Exclude blanks in IF Formula (simple formula)

Hello all

I have a formula in colum J and I

=IF(J3>I3,"Overdue","Deadline met,,""")

CelL I3 is currently blank so I want my IF formula to not return a value as J3 is bigger than I3 (as J3 has a value).

How do I write my formula to say do not return anything i.e overude or deadline met if J3 has a value (always will) and column I/cell I3 does not havbe a value as it won't always?

thank you!

thank you belinda200

but this is still an issue - if J3 has a figure of 14, I3 does not have a figure (blank), I am seeing 'overdue' (j3 is bigger than I3) so K3 where the formula is: shows overdue?

Then I3 is not blank even if it appears so. Test by putting "=LEN(I3)" (without double quotes) in a cell: If I3 is blank it will be 0..

thank you John, think I've resolved it now