Distribute proportionately

Basing on Target and Actual data i would like to measure score between 0 to 150.

For eg. cell A1 is for TARGET which contain 95% and cell B1 is for ACTUAL which contain 96%. I want score in C1 cell.

logic in measuring score are as follows.

if A1 (TARGET)=B1 (ACTUAL), then score 100
if B1=100% then score 150
if B1=0% then score 0

otherwise score will be distributed proportionately.

ie. =if(B1=0,0,if(A1=B1,100,..........))

i cannot set any formula so that score can be distributed proportionately, for which if B1=100% then score will be 150 and so on.

pls help to set such complete the formula

I don't understand this line:

otherwise score will be distributed proportionately.

Proportionately over what range of cells according to what criteria?

To do just the first three, =IF(A1=B1,100,IF(B1=1,150,IF(B1=0,0,"")))

Hi darkyam,

Value of A1 (TARGET) is fixed. Let it is 95%. B1 cell value can be from 0% to 100%. Score would be from 0 to 150.

Hi Donkey,

score will be 150 only when actual is 100%

Dear shg,

Target is always fixed. ie. 95%. So,
if Actual is 95% score is 100
if Actual is 100% score is 150
if Actual is 0%, score is 0

SCORE from 1 to 99 need to be distributed for ACTUAL from 1% to 94% and
SCORE from 101 to 149 need to be distributed for ACTUAL from 96% to 99%