Formulae Help

[philb99]

I have a formulae which you can see returns Y, N or # NUM! where column A is a start date and Column B is the finish date. If no finish date you get
# NUM!

IF(ISNUMBER(DATEDIF(A30,B30,"d")),IF(C30<=90,"Y","N"),"# NUM!")

I have another formulae which looks for the result and if Y or N then all ok but if # NUM! is recorded I do not get a reply when I should. If I manually change to #NUM ! (no gap) then ok

IF(ISERR(D30)=TRUE,NETWORKDAYS(A30,$E$1),"")

Can anyone help please

 

[pgc01]

Hi

If D30 is the cell that has the first formula in your post, then you are using the string "# NUM!" and that's what you should use in the comparison:

IF(D30="# NUM!",NETWORKDAYS(A30,$E$1),"")

 

[philb99]

That's brilliant - thank you

 

[pgc01]

You're welcome.