I have struggled with this problem for 2 days, i hope somebody can help.

DESCRIPTION Data Scoring Sub Score
Gearing is < 100% 0.00% 5
Gearing is Between 100% and 125% 0.00% 3
Gearing 125% 223.34% 1

i am trying to allocate the scores under Scoring Column to the items under
the Data column and place them under the Sub Score column. eg Only if the
item under the Data column is not 0.00% must the corresponding number under
Column C be placed Under the corresponding cell under Sub Score, otherwise
leave blank or put zero. The first item under the Data column was obtained
from another worksheet named Ratio Analysis using the following formula:
=IF('Ratio Analysis'!$E$25100%<125%,'Ratio Analysis'!$E$25,"0.00%")