Help With If And Or

[Rikuk]

Hi need help with the following I've a cell with a value of between 3 &
11, I need to see if that cell meets a criteria to rate accordingly.

between 3 & 5 = 8 points
between 6 & 10 = 9 points
11+ = 10 points

Rik

 

[broro183]

Hi Rik,

Try this:

=IF(K9<3,"what should this be,
zero?",IF(AND(3<=K9,K9<=5),8,IF(AND(6<=K9,K9<=10),9,10)))

where K9 is the cell you want to check.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

 

[Don Guillett]

try
=IF(H8>10,10,IF(H8>5,9,IF(H8>3,8,0)))

 

[Rikuk]

Thank You work perfectly.

Rik

 

[Don Guillett]

glad to help

 

[broro183]

Looks good, Don,

Much tidier than my version - I just need to adjust my way of working
to the solution. I think I went at this one a bit too literally.

Rob Brockett
NZ
Always learning & the best way to learn is to experience...

 

[Don Guillett]

using this, best to work from the highest figure down

 

[Dana DeLouis]

Another option assuming only numbers in A1. I'm not sure about numbers like
5.5 & 10.5. :>o
=8*(A1>3)+(A1>5)+(A1>10)

 

[Guest]

hi,
try this.
I put 3 in A5, 7 in A6 and 12 in A7. this forumla produced 8 in B5, 9 in B6,
10 in B7 and nothing in B8.
=IF(AND(A7>=3,A7<=5),8,IF(AND(A7>=6,A7<=10),9,IF(A7>=11,10,"")))
if the cell contains nothing, the formula displays nothing so if you want it
to display something like a zero then change the double quotes to a zero or
put text between the quotes.

Regards,
FSt1