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

2017 ACTUARIAL SALARY SURVEYS
Contact DW Simpson for a Personalized Salary Survey

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,765
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,410
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,765
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,476
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,514
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,008
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: 24,848
Default

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

?
__________________
Quote:
Originally Posted by Donald J Trump
I was going to fire Comey knowing, there was no good time to do it. And in fact when I decided to just do it, I said to myself, I said you know, this Russia thing with Trump and Russia is a made up story
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,404
Default

Meh. VLOOKUP. I do this all the time.

/thread
__________________
DTNF's Basic Philosophy Regarding Posting: There's no emoticon for what I'm feeling! -- Jeff Albertson (CBG)
DTNF's Trademarked Standard Career Advice: "pass some exams and get back to us."
DTNF's Major advice: "Doesn't matter. Choose major that helps you with goal of Career Advice."
DTNF's Résumé Advice: Have a good and interesting answer to every item on it for the interviews.
DTNF's Law of Job Offers: You not only have to qualify for the position, but you also have to be the best candidate available for the offer.
DTNF's Work Philosophy: I am actuary. Please insert data. -- Actuary Actuarying Rodriguez.
Twitches' Advice to Crazy Women: Please just go buy your 30 cats already.
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 02:07 PM.


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.18318 seconds with 9 queries