# Excel IF Function help

Microsoft Office excel 2007 - upgrade
December 4, 2010 at 05:22:28
Specs: Windows XP
 Hi guysGot 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:=IF(Sheet1!B17<10,0,IF(Sheet1!B1>=10,1,IF(Sheet1!B1>=20,2)))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 = 0between 10 and 20 = 1 between 20 and 30 = 2between 30 and 40 = 3 and so on... any help would be greatly appreciated!Ben

See More: Excel IF Function help

#1
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.DerbyDad03Office Forum ModeratorPosting Tip: Before posting Data or VBA Code, read this How-To.

Report •

#2
December 4, 2010 at 09:01:28
 There are two issues with your question:First, your Nested IF:=IF(Sheet1!B17<10,0,IF(Sheet1!B1>=10,1,IF(Sheet1!B1>=20,2)))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?Second: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