Excel IF Function help

Microsoft Office excel 2007 - upgrade
December 4, 2010 at 05:22:28
Specs: Windows XP
Hi guys

Got a simple problem, I believe, on excel but just can't seem to get to the bottom of it.

as a starting point I have this formula:


basically i have a lot of information that I want to give a value to.

So if a cell is between a certain parameter it will be a certain value.

so below 10 = 0
between 10 and 20 = 1
between 20 and 30 = 2
between 30 and 40 = 3

and so on...

any help would be greatly appreciated!


See More: Excel IF Function help

Report •

December 4, 2010 at 08:51:17
In the future, please try to use a Subject Line that is relevant to your question. Since all threads get saved in the Archives, it helps if the Subject Line has something to do with the content of the post.

I have edited the Subject Line of this thread.

Office Forum Moderator

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •

December 4, 2010 at 09:01:28
There are two issues with your question:

First, your Nested IF:


The first condition of this function checks B17, the rest check B1. You said:

Is the B17 a typo or is B17 < 10 actually the first (therefore the highest priority) condition to be checked?


and so on...

What does that mean?

Depending on how many conditions you have to check and depending on what version of Excel you are running, there are multiple ways to address your requirements.

Give us a little more detail and we can do a better job of helping you.

Make sure you include the Excel version you are running.

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •

Related Solutions

Ask Question