If value matches criteria, return formula

  • Thread starter Thread starter DJ
  • Start date Start date
D

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?
 
X, Y and Z represent 0% of max, 50% of max
and 150% of max respectively
Click to expand...

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)),"")
 
Back
Top