IFERROR and IF ISBLANK in same formula

[reneekeane]

hi there, i am trying to write a formula that can do if error (to get rid of the #VALUE results and IF(ISBLANK) to take care of not doing the calculation if the data has not been entered yet in the same formula.

so if B2 has text and not a date (IFERROR) and then in B2 is blank then "" otherwise B2-B1

 

[AhoyNC]

Try
=IF(OR(ISTEXT(B2),B2=""),"",B2-B1)

 

[reneekeane]

Try
=IF(OR(ISTEXT(B2),B2=""),"",B2-B1)

Thanks, that works in most cases but sometimes there may be text in B1 aswell instead, is there something else to add into the formula so that is works for both B1 and B2 when either is not a date or blank? thanks

 

[reneekeane]

Thanks, that works in most cases but sometimes there may be text in B1 aswell instead, is there something else to add into the formula so that is works for both B1 and B2 when either is not a date or blank? thanks

also sometimes B1 might be the cell that is blank

 

[AhoyNC]

=IF(OR(ISTEXT(B2),ISTEXT(B1),B2="",B1=""),"",B2-B1)

 

[Peter_SSs]

What about

=IF(COUNT(B1:B2)=2,B2-B1,"")

 

[reneekeane]

=IF(OR(ISTEXT(B2),ISTEXT(B1),B2="",B1=""),"",B2-B1)

That worked perfectly! Thank you so much

 

[Peter_SSs]

Just wondering .. did the simpler subsequent suggestion not work?

 

[reneekeane]

What about

=IF(COUNT(B1:B2)=2,B2-B1,"")

Thank you - yes this formula also works

 

[Peter_SSs]

Cheers. Thanks for testing.