# 3/3 cells at 90% or greater receive 100%, 2/3 cells at 90% receive 75% 1/3 at 90% receive 0

#### debralee

##### New Member
I have searched for hours to do this and my brain hurts.
Please help me.

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### Eric W

##### MrExcel MVP
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.

Last edited:

#### debralee

##### New Member
Thank you so very much!!!!!!!!!
This site is amazing!!

Your the best!!

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.

Happy to help!

Happy New Year!

Replies
3
Views
309
Replies
4
Views
595
Replies
5
Views
286
Replies
4
Views
1K
Replies
9
Views
404

Threads
1,190,781
Messages
5,982,867
Members
439,802
Latest member
Teiho

### 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

### 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