Formulae Help

philb99

Active Member
Joined
Feb 3, 2014
Messages
295
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

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,737
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),"")
 

Forum statistics

Threads
1,078,240
Messages
5,339,031
Members
399,274
Latest member
WilliamWavehill

Some videos you may like

This Week's Hot Topics

Top