add another condition to iserror

Topic

New Reply

=IF(ISERROR(DATEDIF(B5,B6,”d”)),”waiting”,REPT(“I”,C5))
B column has date entries.
B5 is first date entry.
B column [dates] filled in descending order, so no B5, never B6.
If B5 is blank[no first entry], I get no output, “waiting”.
How can I get it to also give me this output if B5 is blank?

Reply | Quote

Replies

Try:

=IF(OR(B5=””,ISERROR(DATEDIF(B5,B6,”d”))),”waiting”,REPT(“I”,C5))

Reply | Quote

Rory,
Thanks.

Reply | Quote