If value matches criteria, return formula

[DJ]

I'm creating a calculator that returns a value based on a set of criteria.
One example: scores below 0% should return X value, between 0-10% should
return Y value, scores greater than 10% should return Z value. X, Y and Z
represent 0% of max, 50% of max and 150% of max respectively. Any ideas?

 

[T. Valko]

X, Y and Z represent 0% of max, 50% of max

and 150% of max respectively

Max of what?

Let's assume "max" is 100.

=IF(COUNT(A1),IF(A1<0,0,IF(A1<=10%,100*0.5,100*1.5)),"")

 

[DJ]

Worked like a charm, you're the best!

Max of what?

Let's assume "max" is 100.

=IF(COUNT(A1),IF(A1<0,0,IF(A1<=10%,100*0.5,100*1.5)),"")

 

[T. Valko]

You're welcome. Thanks for the feedback!