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%")

That formula is not syntactically correct, and it returns "0.00%" as a
string - is this what you want?

Anyway, I think what you want under your Sub Score column is this:

=IF(B2="0.00%","",C2)

and then copy down as required.

Hope this helps.

Pete

On Aug 22, 12:44*am, DJ wrote:
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%")