#VALUE! error

[phillipcook]

Hi everyone.

Is there a way to make this formula an IFERROR formula

=IF(AND(NETWORKDAYS(B2,B2,$X$2:$X$22)>0,H2<0.25),H2-G2,"")

Sometimes this formula is returning a [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! error due to cells H2 and G2 not having times in them or B2 not having a date.

Is there a way to make the [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! show up as a blank cell?

 

[Scott T]

try

=IFERROR(IF(AND(NETWORKDAYS(B2,B2,$X$2:$X$22)>0,H2<0.25),H2-G2,""),"")

 

[phillipcook]

That worked a treat!!! thanks a heap mate!!!