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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need someone to examine this formula... 5
Finding dynamic maxima 8
iserror 4
if(iserror()) question 2
ISERROR on VLOOKUP 3
Iserror with if(or & Vlookups 5
Find 3 If(Iserrors instead of 1 7
Formula for selecting a Leap Year. 7

Back
Top