Help on IF formula, values from 175-260

[Kamato25]

I have values in a worksheet that are from 175 - 260 and I want to but a score on them in a separate column (B).

values of >= 260 will be 50, 200-225 will be 45, 175-199 will be 40.

Here is my formula, and it is only putting a value in cells that have 260. everything else is getting 0's.
=IF(A2>=260,50,0)+IF(A2>=200<=225,45,0)+IF(A2>=175<=199,40,0)

A B (Score)

260 50
175 0
260 50
225 0
175 0
225 0

Any suggestions?

 

[Jonmo1]

Welcome to the board.

This should be pretty simple with a Lookup function.
But you need to more clearly define the ranges...

What about 226 to 259 ?
What about Below 175 ?
Will there be 0's and/or negatives ?

 

[kevatarvind]

try like below

=IF(A2>=260,50,IF(AND(A2>=200,A2<=225),45,IF(AND(A2>=175,A2<=199),40,0)))

 

[Kamato25]

Hi kevatarvind,

This worked! Thank you so much!

 

[kevatarvind]

Thanks For The Feedback

Your Welcome

 

[Aladin Akyurek]

I have values in a worksheet that are from 175 - 260 and I want to but a score on them in a separate column (B).

values of >= 260 will be 50, 200-225 will be 45, 175-199 will be 40.

Here is my formula, and it is only putting a value in cells that have 260. everything else is getting 0's.
=IF(A2>=260,50,0)+IF(A2>=200<=225,45,0)+IF(A2>=175<=199,40,0)

A B (Score)

260 50
175 0
260 50
225 0
175 0
225 0

Any suggestions?

Welcome to the board.

This should be pretty simple with a Lookup function.
But you need to more clearly define the ranges...

What about 226 to 259 ?
What about Below 175 ?
Will there be 0's and/or negatives ?

The question above needs/deserves an answer though... for something like:

=LOOKUP(A2,{0,175,200,226,260},{0,40,45,0,50})

would be concise and appropriate. Adjust to install the missing/marked criteria and result values.