IF Statement

[Susan Ireland]

I am trying to create a IF statement that will take value in cell V3
and if its greater than 90% but less than or equal to 100% lookup up a
table and return a value from the table.

This is what I have so far and I know it's not right (as it doesn't
take into account values greater than 90%) but can't work out how to
correct it -

=IF(V4<=1,(LOOKUP(V4,Tables!$B$4:$C$104)*R4),0)

Help!

 

[Don Guillett]

=IF(V4<=1,(LOOKUP(V4,Tables!$B$4:$C$104)*R4),0)
=IF(and(v4>.9,V4<=1),(LOOKUP(V4,Tables!$B$4:$C$104)*R4),0)

 

[Peo Sjoblom]

One way,

=IF(AND(V4<=1,V4>0.9),(LOOKUP(V4,Tables!$B$4:$C$104)*R4),0)

 

[gbowes]

Try something like this:
=IF((V4>=.9 AND V4<=1),(LOOKUP(V4,Tables!$B$4:$C$104)
*R4),0)

The Boolean 'AND' operator requires BOTH conditions:
greater than/equal to 90% through LessThan/Equal to 100%

gary b

 

[Don Guillett]

Did you try this?

 

[Susan Ireland]

One way,

=IF(AND(V4<=1,V4>0.9),(LOOKUP(V4,Tables!$B$4:$C$104)*R4),0)


--

Regards,

Peo Sjoblom

Thanks for you help Peo.

 

[Susan Ireland]

=IF(and(v4>.9,V4<=1),(LOOKUP(V4,Tables!$B$4:$C$104)*R4),0)

Thanks for your help Don.