# IF statement Problem

#### seenfresh

##### Well-known Member
I have the following IF statement and I seem to have a Reference error!

Does anybody notice anything suspicious!

=IF(N14>1,INDEX(N14,14),IF(AND(N14>0,N14<1),INDEX(ROUNDUP(N14,0),14,)))

I've been at this for a while, maybe someone can spot something for me

Would be much appreciated

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

##### MrExcel MVP
Everything to it is suspicious as long as it's not clear what this formula is supposed to do. Care to state the problem in English instead of Excelese?

#### seenfresh

##### Well-known Member

IF Value(N14) is greater than 1, return the value(N14)

IF Value(N14) is not then round up (N14) to nearest whole number only If it is greater than 0, but less than 1 and return its roundup(N14)

N(14) will never hold a negative value

Hope my spanglish makes sense,

Thanks Again!

##### MrExcel MVP
Is it not...

=IF(N14>1,N14,IF(AND(N14>0,N14<=1),1,""))

Edited for misplaced parens...

#### seenfresh

##### Well-known Member
I have entered

=IF(N93>1,N93,IF(AND(N93>0,N93<=1,1),""))

Cell(N93) value holds 0.06

The function returns blank!

But then I realized the bracket missplacement in the False argument statement!

And now it works great!

You are the man

Cheers!

Sean

Replies
3
Views
77
Replies
2
Views
177
Replies
4
Views
105
Replies
5
Views
188
Replies
1
Views
178

1,137,340
Messages
5,680,916
Members
419,945
Latest member
Carrie Sellers

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back