If value matches criteria, return formula
 

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?

If value matches criteria, return formula
 

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

--
Biff
Microsoft Excel MVP


"DJ" wrote in message
...
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?

If value matches criteria, return formula
 

Worked like a charm, you're the best!

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"DJ" wrote in message
...
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?

If value matches criteria, return formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"DJ" wrote in message
...
Worked like a charm, you're the best!

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"DJ" wrote in message
...
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?