Cannot fit ISERROR to this IF formula

I'm scratching my head of how to fit in ISERROR to this formula I use

=IF(M4>H4,"No",IF(M4<=H4,"Yes"))

I tried to use this way but there's an error on "No"

=IF(ISERROR(M4>H4,"No",IF(M4<=H4,"Yes")),"",M$>H4,"No",IF(M$<=H4,"Yes""))

thanks in advance

Firstly do you need two IFs, if the first condition doesn't hold then the second must so you can use just

=IF(M4>H4,"No","Yes")

adding ISERROR would then give you

=IF(ISERROR(IF(M4>H4,"No","Yes")),"",IF(M4>H4,"No","Yes"))

but as M4 and H4 must contain errors for that formula to give you an error you could probably shorten like

=IF(ISERROR(M4&H4),"",IF(M4>H4,"No","Yes"))

thank you daddylonglegs for replying
you've shorten my formula in a very impressive way but when I copy your formula (one of both formula you created) to a whole column ( column O ) the cells contain "Yes" instead of empty.

In column M & H, there are some empty cells that does not contain dates yet and I want cells in column O to get ready for any date input in column H & M

hope this make sense

Elected Members Requests DUMMY2.xls

Ok, but then ISERROR may not be appropriate - if the cells are blank your initial formula doesn't cause an error.

Assuming you only want the calculation to go ahead if both cells are populated (with dates) you can use this version

=IF(COUNT(M4,H4)=2,IF(M4>H4,"No","Yes"),"")

Yep brilliant, thank you very much for your quick help daddylonglegs, much appreciated.

Had no idea that your formula can be use without ISERROR

Gee wish I have some knowledge like you have.........

Cheers mate