Same thing but looking within a range

Posted on 2011-09-28
Medium Priority
Last Modified: 2012-05-12

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
Question by:vegas86
LVL 23

Accepted Solution

Michael Fowler earned 2000 total points
ID: 36812863
An IF statement stops calculating once it reached a statement that is true therefore you can use the following



Author Closing Comment

ID: 36812879
Thanks again Michael!! :)

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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.

Join & Write a Comment

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

607 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