Microsoft Office Forums Alternative for Multiple If Conditions?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2017, 12:40 AM
zguan1 zguan1 is offline Alternative for Multiple If Conditions? Windows 10 Alternative for Multiple If Conditions? Office 2016
Novice
Alternative for Multiple If Conditions?
 
Join Date: May 2017
Posts: 2
zguan1 is on a distinguished road
Default Alternative for Multiple If Conditions?

Hello,
I am seeking help to find a way to include multiple IF conditions (51 of them) in one formula. I have outlined the background below:

I have two tables: Table 1 contains a division code for each of the 52 states. And table 2 has account names and their respective state info. I am trying to map the division code for each of the accounts based on their state in table 1. One logic I can think of is =if(State ="AK", "1.5","") OR if(State = "AL","2.3","") OR if(State="AR", "4.1","").......etc - includes all 52 states in this formula. This is just the logic, I was wondering 1) what would be the correct formula to include all the if functions in one formula? 2) is there a better way to capture what I am looking for (division code)? Thank you




 Table 1 State Division Code AK 1.5 AL 2.3 AR 4.1 AZ 5.9 CA 6.6 CO 7.5 CT 8.8 DC 10.1 DE 11.4 FL 12.7

Table 2
Account State Division Code 1 AK 2 HI 3 AK 4 HI 5 AR 6 CO 7 AR 8 CO 9 IL 10 CO
Reply With Quote
  #2  
Old 05-25-2017, 01:17 AM
xor xor is offline Alternative for Multiple If Conditions? Windows 10 Alternative for Multiple If Conditions? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Here is one option.
Attached Files
File Type: xlsx DivisionCode.xlsx (14.3 KB, 7 views)
Reply With Quote
  #3  
Old 05-25-2017, 09:12 AM
zguan1 zguan1 is offline Alternative for Multiple If Conditions? Windows 10 Alternative for Multiple If Conditions? Office 2016
Novice
Alternative for Multiple If Conditions?
 
Join Date: May 2017
Posts: 2
zguan1 is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Here is one option.
Thank you very much!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula for Multiple Conditions & Results nowco Excel 4 03-16-2016 11:24 AM
Alternative for Multiple If Conditions? Using multiple conditions with an IF statement?? to show a yes/no value BlindMouse Excel 1 01-27-2016 12:19 AM
Alternative for Multiple If Conditions? Multiple If Conditions z941714 Excel 8 08-09-2015 04:12 PM
Alternative for Multiple If Conditions? multiple conditions, and blank cells with the countifs function jaden0605 Excel 1 03-30-2014 01:50 AM
Alternative for Multiple If Conditions? Count with multiple conditions bundy5150 Excel 4 02-22-2011 10:00 AM


All times are GMT -7. The time now is 04:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft