If value matches criteria, return formula

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?
 
T

T. Valko

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

More if then logic 2
More if then logic 2
return multiple values when within range (greater than and less than) 11
Simple COUNTIF function help 3
Use TODAY() function as the criteria in a SUMIF formula 1
Max Value, Sum Product, Between Date Range 4
Excel VBA macro, search - accumulate - delete original 0
SUMIF "value if false" not working 2

Top