Nested If Function
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:
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.
Please Login or Register to view this content.
Thanks
Perhaps..
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try
=MATCH(H2/15,{0,50,100,150,200})
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)))
Click (*) if you received helpful response.
Regards,
David
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!
You're welcome.
Eh, I got too excited, Jonmo! The cell is not updating when I change the calculations in the H cells
Post a few examples of the values in H2, and your expected results based on those values.
Perhaps you could post an actual workbook
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.
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})
Thank you, Jonmo! That was it. I apologize.
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.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks