# Thread: Help with Combining IF with ISERROR statements

1. Registered User
Join Date
Mar 2004
Location
St. John's, NFLD
Posts
18

## Unanswered: Help with Combining IF with ISERROR statements

Hello, Just wondering if any one would have a quick fix solution, I've been looking at this for what seems hours??

I want to combine these 2 lines into one, but cant seem to do it.

=IF(ISERROR(ROUNDUP(MAX(M15:M18), 2)), "NA", (ROUNDUP(MAX(M15:M18), 2)))

=IF('Step 1'!B7>10,'Step 1'!D10*ROUNDUP(MAX(M15:M18), 2), IF('Step 1'!B7<=10,ROUNDUP(MAX(M15:M18), 2)))

Basically I want the ISERROR to cover off the parameters B7>10 and B7<=10 and their resultant calculations. So it might look something like this:

=IF(ISERROR(IF('Step 1'!B7>10,'Step 1'!D10*ROUNDUP(MAX(N15:N18), 2), IF('Step 1'!B7<=10,ROUNDUP(MAX(N15:N18), 2)), "NA", ('Step 1'!B7>10,'Step 1'!D10*ROUNDUP(MAX(N15:N18), 2), IF('Step 1'!B7<=10,ROUNDUP(MAX(N15:N18), 2))))

Thanks for any help I can get! This seems very tricky!

P.S. Both these lines work independently I just want to be able to combine them into one.

2. Registered User
Join Date
Mar 2004
Location
Fort Worth, Texas, USA
Posts
68
Is it feasible to put a function in N15:N18 that ensures a value is always present? That would simplify the logic in your calculation cell, i.e.

=IF(MAX(N15:N18)<10, do this, do that)

3. Registered User
Join Date
Dec 2003
Location
San Diego, CA
Posts
153
Welcome to the Board!

Why don't you post your workbook (.zip) and someone can take a look at it. A lot of your formula seems erroneous and the ISERROR can cause you more problems than you want if the formula isn't debugged to begin with.

Try removing the ISERROR portions, then nest the formulas. If you really want the ISERROR after that, add it back in once the formula works.

Hope that helps,

Smitty

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•