Nested If Function

[onemoremile]

Hi:

I am trying to use the nested if statement in my spreadsheet, but keep getting an error.

I am trying to take a value in cell H, divide it by 15, and depending on the range show a ranking between
1 thru 5.

What I tried:

Please Login or Register  to view this content.

I think I just need another (or more) pair of eyes to look at what my burned out eyes can't see. Any help would be appreciated.

Thanks

[Fotis1991]

Perhaps..

Please Login or Register  to view this content.

[Jonmo1]

Try

=MATCH(H2/15,{0,50,100,150,200})

[SDCh]

I think you miss ) on the red one
If(AND((h2/15)>100, (h2/15)<=149.9,3)
If(And (h2/15)>150,(h2/15)<=199.9,4)

For this I think you not need "AND"
If(And(h2/15>200,5)))

[onemoremile]

Thank you all for quick response!

@Fotis: still getting error with that. I played around with the parentheses and still nothing. Thank you though!
@Jonmo: that appears to work. Thank you!
@Sdch: still got an error with the parentheses manipulation. It could very well be that my eyes are seriously in need of a break. This is a massive spreadsheet that is essentially a database. Thank you though!

[Jonmo1]

You're welcome.

[onemoremile]

Eh, I got too excited, Jonmo! The cell is not updating when I change the calculations in the H cells

[Jonmo1]

Post a few examples of the values in H2, and your expected results based on those values.

Perhaps you could post an actual workbook

[onemoremile]

Example.xlsx

Here's an example file. For every "solution percent" I need the ranking
based on 15%.

Thank you and let me know if there is anything else I should clarify.

[Jonmo1]

You didn't metion anything about percentages in your post..

50 Percent is NOT greater than 49.9

100 Percent = 1
50 Percent = 0.5

Try
=MATCH(H2/15,{0,0.5,1,1.5,2})

[onemoremile]

Thank you, Jonmo! That was it. I apologize.

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[Jonmo1]

You're welcome.