Need help adding ISERROR !

  • Thread starter Thread starter soltek
  • Start date Start date
S

soltek

I have these two formulas that for the love of me cant get to work in
ISERROR.

=NETWORKDAYS(Q9,R9)

and

=IF(U8="D",L8+3,IF(U8="S",L8+5))

This second one seems to do what I want it to but it just doesnt look
right to me. And when I try and add the ISERROR to it, it tells me the
"3" is an extra value to the formula.
If anybody has ideas on these 2 I would be greatly appreciative.
Thanks in advance.
 
=IF(U8="D",L8+3,IF(U8="S",L8+5))

This second one seems to do what I want it to but it just doesnt look
right to me.
Click to expand...

What if U8 is neither D nor S? What do you want to happen? Right now it
returns FALSE.
 
Back
Top