IF statement Problem

seenfresh

Well-known Member
Joined
Jul 12, 2006
Messages
1,141
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,
 

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)

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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
Joined
Jul 12, 2006
Messages
1,141
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!
 

seenfresh

Well-known Member
Joined
Jul 12, 2006
Messages
1,141
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
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top