IF function

[tsshchi]

I want to create two cell, 1st cell value will be between score 0-100, 2nd cell will be shown in % based on the value in the 1st cell

Example: 1st cell is A1 and 2nd is A2

When A1= 98-100, A2=100%
When A1= 97-91, A2=90%
When A1= 90-86, A2=80%
When A1= 85-81, A2=70%
When A1= 80-76, A2=60%
When A1= 75-71, A2=50%
When A1= 70-66, A2=40%
When A1= 65-61, A2=30%
When A1= 60-56, A2=20%
When A1= 55-51, A2=10%
when A1= 50-0 , A2=0%

I want to use IF function on cell A2 to show the above result.
Appreciate if you can show me the logical equation on this.

 

[BrianJN1]

I want to create two cell, 1st cell value will be between score 0-100, 2nd cell will be shown in % based on the value in the 1st cell

Example: 1st cell is A1 and 2nd is A2

When A1= 98-100, A2=100%
When A1= 97-91, A2=90%
When A1= 90-86, A2=80%
When A1= 85-81, A2=70%
When A1= 80-76, A2=60%
When A1= 75-71, A2=50%
When A1= 70-66, A2=40%
When A1= 65-61, A2=30%
When A1= 60-56, A2=20%
When A1= 55-51, A2=10%
when A1= 50-0 , A2=0%

I want to use IF function on cell A2 to show the above result.
Appreciate if you can show me the logical equation on this.

I have one big question:
What is the rationale that A2 = xxx% for A1 being between yyy and zzz?

 

[Legacy 143009]

This sould make your day

=IF(A1<51,0,IF(AND(A1>90,98>A1),90,CEILING((A1-50)*2,10)))/100

Don't forget to format A2 as Percentage

 

[tsshchi]

This sould make your day

=IF(A1<51,0,IF(AND(A1>90,98>A1),90,CEILING((A1-50)*2,10)))/100

Don't forget to format A2 as Percentage

OMG!!!You are absolute right!!!! You did just make my day

Salute from Hong Kong!!! Thx man.