If then / but statement question

[RFloyd75]

<DIR>

I am tyring to build a formula that says if it is 88% or greater but less than 90% give me $1,000, If it is 90% or greater but less than 92% than $1,250, IF it is 92% or greater then $1,500, else zero.

Any suggestions!!​

</DIR>

 

[schielrn]

Welcome to the Board!

Try:

=if(a1<.88,0,if(a1<.9,1000,if(a1<.92,1250,1500)))

or:

=if(a1>=.92,1500,if(a1>=.9,1250,if(a1>=.88,1000,0)))

You can also use lookup or vlookup for this, but I have to go and this was easier for me to type out.

Hope that helps.

 

[jbeaucaire]

This should do it:

=LOOKUP(A1,{0,0.88,0.9,0.92},{0,1000,1250,1500})

The percentage to evaluate is in A1.

 

[Colin Legg]

For fun here's another way:

=1000*(A1>=88%)+250*(((A1>=92%)+(A1>=90%)))

which could also be written as:

=1000*(A1>=0.88)+250*SUM(--(A1>={0.92,0.9}))

 

[RFloyd75]

schielrn

This appears to have worked. Thank you so much!!!

Everyone else thank you for your replys and help!