How to use IFERROR IF and ISBLANK in together?

[taylorsm]

=IFERROR(IF((C$11<>"Yes"),"", C$9+((C$8-C$10)/24)),"")

I want to add ISBLANK(C$9),"",

[Pete_UK]

Try it like this:

=IFERROR(IF(OR(C$11<>"Yes",ISBLANK(C$9)),"", C$9+((C$8-C$10)/24)),"")

(changes in red).

Hope this helps.

Pete

[Richard Buttrey]

Hi,

Presumably

=IF(AND(ISBLANK,C9),IFERROR(IF((C$11<>"Yes")),"", C$9+((C$8-C$10)/24)),"")

[taylorsm]

I get a "problem with formula"

[Pete_UK]

You've been given two formulae - which one are you having a problem with?

Pete

[Tony Valko]

It looks like Richard's is the problematic formula.

=IF(AND(ISBLANK,C9),IFERROR(IF((C$11<>"Yes")),"", C$9+((C$8-C$10)/24)),"")

ISBLANK,C9

IF((C$11<>"Yes")),"",

[taylorsm]

Yes sorry, I hit reply to Richard's post, petes works great. thank you guys!

[Pete_UK]

You're welcome - thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete