-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
3/3 cells at 90% or greater receive 100%, 2/3 cells at 90% receive 75% 1/3 at 90% receive 0
- Thread starter debralee
- Start date
Eric W
MrExcel MVP
- Joined
- Aug 18, 2015
- Messages
- 12,627
Welcome to the forum.
It's helpful if you could give specific examples of what you are asking. Like what cells have the values, and so on. However, here's one idea:
=CHOOSE(COUNTIF(A1:A3,">=90%")+1,0,0,75%,100%)
If the cells you are looking at are A1, A2 and A3, then the above formula might work for you. Let me know.
It's helpful if you could give specific examples of what you are asking. Like what cells have the values, and so on. However, here's one idea:
=CHOOSE(COUNTIF(A1:A3,">=90%")+1,0,0,75%,100%)
If the cells you are looking at are A1, A2 and A3, then the above formula might work for you. Let me know.
Last edited:
Upvote
0
Upvote
0
Similar threads
- Question
