IF statement Problem

[seenfresh]

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

Thanks in advance,

 

[Aladin Akyurek]

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]

lol my bad!

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!

 

[Aladin Akyurek]

Is it not...

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

Edited for misplaced parens...

 

[seenfresh]

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