IF Statement calculation

[Michelle]

I am trying to write an IF statement that assigns point
values to a calcualtions.

For example If a number is 0.7 or above then assign 100.
If the number is between 0.69 and 0.51, then assign 50. If
the number is .50 and below then 0.

How do I write an If statement that has all of these
variables.


Thanks for your help.

 

[L. Howard Kittle]

Hi Michelle,


Try a vlookup.

A1 = 0
A2 = .51
A3 = .7
B1 = 0
B2 = 50
B3 = 100

In E1 enter =VLOOKUP(D1,A1:B3,2,1)

In D1 enter the lookup value.

0 to .5 returns 0
..51 to .69 returns 50
..7 and over returns 100

HTH
Regards,
Howard

 

[Frank Kabel]

Hi Michelle
instead of the (more flexible/expandable) VLOOKUP solution for only 3
conditions you may want to use the following IF construct:
=IF(A1>=0.7,100,IF(A1>=0.51,50,0))

Frank