Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Fill in a brief DW Simpson Registration Form
to be contacted when new jobs meet your criteria.


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 12-13-2017, 11:44 AM
llcooljabe's Avatar
llcooljabe llcooljabe is offline
Member
CAS
 
Join Date: Aug 2002
Posts: 22,820
Default dumb excel question

Is there an alternative to a nested if? I don't want to create a table on which to use index/match or a lookup function.

e.g.
if(cell= text1,result A, if (cell = text2, result B, result C))

I could create a table like below and use a lookup function or index/match, but i don't want to for a one time formula with 3-5 options.
Text1 ResultA
Text2 ResultB
Text3 ResultC
__________________
www.GoodNewsNow.info
Propoganda
Reply With Quote
  #2  
Old 12-13-2017, 11:54 AM
Kenny's Avatar
Kenny Kenny is offline
Member
Non-Actuary
 
Join Date: Jan 2003
Posts: 7,459
Default

IFS?
__________________
I am a scientist. I am sorry to disappoint you but I have never seen an elf or a troll. But who am I to exclude their existence? - Arni Bjoernsson
You are stupid and evil and do not know you are stupid and evil. ... Dumb students are educated stupid. - timecube.com
Usually while I'm reading, I'm actually thinking about...midgets riding toy horses - Roto


Reply With Quote
  #3  
Old 12-13-2017, 11:57 AM
llcooljabe's Avatar
llcooljabe llcooljabe is offline
Member
CAS
 
Join Date: Aug 2002
Posts: 22,820
Default

only available in office 365.
__________________
www.GoodNewsNow.info
Propoganda
Reply With Quote
  #4  
Old 12-13-2017, 12:01 PM
SlowMotionWalter's Avatar
SlowMotionWalter SlowMotionWalter is offline
Member
CAS
 
Join Date: Jun 2013
Posts: 12,588
Default

You nest those IFs and be happy you can now do more than 7.
__________________
Quote:
Originally Posted by bigb View Post
You should learn to communicate in a serious manner before you expect a serious answer.
Spoiler:
Quote:
Originally Posted by Kangaz wit Attitude View Post
Force of habit, 2pac's been typing "88" a LOT since Trump got elected.
Quote:
Originally Posted by JMO View Post
You ought to see the bush. It's impressive.
Quote:
Originally Posted by Pikachu
10:53 pm: some ppl dont take advices well
Quote:
Originally Posted by mayo fan
9:45 pm: ao fan would be hot covered in mayo!
Quote:
Originally Posted by Snikelfritz
if you'd like I can come visit and dress up like a girl and get in some fights
Quote:
Originally Posted by Kaner3339 View Post
i think everyone needs to do this type of thing to get a dose of reality and straighten people up. it's kinda like going to the mountains and becoming a monk except it's with hundreds of potatoes and a lot of stoners with tattoos in a kitchen
Reply With Quote
  #5  
Old 12-13-2017, 12:04 PM
ALivelySedative's Avatar
ALivelySedative ALivelySedative is offline
Member
CAS
 
Join Date: Dec 2013
Location: Land of the Pine
College: UNC-Chapel Hill Alum
Favorite beer: Red Oak
Posts: 2,555
Default

Quote:
Originally Posted by SlowMotionWalter View Post
You nest those IFs and be happy you can now do more than 7.
Reply With Quote
  #6  
Old 12-13-2017, 12:41 PM
Meshuga's Avatar
Meshuga Meshuga is offline
Member
Non-Actuary
 
Join Date: Dec 2001
Posts: 12,054
Default

perhaps the choose function?
__________________
I know I don't talk in my sleep. Someone at work would have told me by now.
Reply With Quote
  #7  
Old 12-13-2017, 12:49 PM
Childish Gambino's Avatar
Childish Gambino Childish Gambino is offline
Member
SOA
 
Join Date: Jul 2014
Posts: 25,153
Default

if(a2&b2&...&x2 = result1&result2&...&resultn,foo,bar)

?
__________________
When fascism comes to America, it will be wrapped in the US Flag and carrying a Cross.
Reply With Quote
  #8  
Old 12-13-2017, 12:55 PM
MoralHazard MoralHazard is offline
Member
CAS
 
Join Date: Jul 2011
Favorite beer: Sam Adams Rebel Rouser
Posts: 94
Default

=IF(A1="Text1", "ResultA", "")&IF(A1="Text2", "ResultB", "")&IF(A1="Text3", "ResultC", "")
Reply With Quote
  #9  
Old 12-13-2017, 12:58 PM
MoralHazard MoralHazard is offline
Member
CAS
 
Join Date: Jul 2011
Favorite beer: Sam Adams Rebel Rouser
Posts: 94
Default

=CHOOSE(MATCH(A1, {"Text1","Text2","Text3"}, 0), "ResultA", "ResultB", "ResultC")
Reply With Quote
  #10  
Old 12-13-2017, 02:28 PM
Dr T Non-Fan Dr T Non-Fan is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 92,648
Default

Meh. VLOOKUP. I do this all the time.

/thread
__________________
"Facebook is a toilet." -- LWTwJO
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 03:37 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.22099 seconds with 9 queries