Solved

Same thing but looking within a range

Posted on 2011-09-28
2
162 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:vegas86
2 Comments
 
LVL 23

Accepted Solution

by:
Michael74 earned 500 total points
ID: 36812863
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
 

Author Closing Comment

by:vegas86
ID: 36812879
Thanks again Michael!! :)
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now