Isserror question

B

Brad

=IF(iserror(B5+1>$B$3+$B$2,"",B5+1),"",(B5+1>$B$3+$B$2,"",B5+1))

Excel keeps saying there is a problem with the first double quotes...

Help please?
 
J

JE McGimpsey

What exactly are you trying to do?

ISERROR() takes one argument. IF() takes three.

As a wild guess:

=IF(ISERROR(B5+1>$B$3+$B$2), "", B5+1)
 

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

Copying formulas but incrementing the worsheet reference 1
Inequalities Function 3
Is it Series Summation? 2
hide row with drop down value 0
Check if a date comes before/after a range of dates 0
Formating bolded text exclusively. 0
If statement in excel 3
Finding the right style field in VBA 0

Top