Same thing but looking within a range

Hello,

I just had a thought, how could I manipulate the above formula to look for a certain range istead of just one number,
For example, what would I do if I had the following ratings range?

Ratings Range
1-2 ticks = 5
3-5 ticks = 4
6-9 ticks = 3
10-12 ticks = 2
12 and over ticks = 1
vegas86Asked:
Who is Participating?
 
Michael FowlerSolutions ConsultantCommented:
An IF statement stops calculating once it reached a statement that is true therefore you can use the following

=IF(COUNTIF(A2:E2,"P")<=2,5,IF(COUNTIF(A2:E2,"P")<=5,4,IF(COUNTIF(A2:E2,"P")<=9,3,IF(COUNTIF(A2:E2,"P")<=12,2,1))))

Michael
0
 
vegas86Author Commented:
Thanks again Michael!! :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.