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

DW Simpson
Actuarial Jobs

Visit our site for the most up to date jobs for actuaries.

Actuarial Salary Surveys
Property & Casualty, Health, Life, Pension and Non-Tradtional Jobs.

Actuarial Meeting Schedule
Browse this year's meetings and which recruiters will attend.

Contact DW Simpson
Have a question?
Let's talk.
You'll be glad you did.


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 12-27-2018, 11:23 AM
Noonien Soong Noonien Soong is offline
CAS
 
Join Date: Sep 2018
Posts: 26
Default Excel: have raw numbers, in one cell can i see if any one is greater than 50% sum

Seasons greetings humans,

To make use case simple, say i have numbers in A1:C1. Is there a way to only use cell D1 to see if any of A1, B1, or C1 is greater than 50% of the total of sum A1:C1?

I'm trying to avoid making D1:F1 = A1/sum(A1:C1), B1/sum(A1:C1), and C1/sum(A1:C1), then having to make G1=if(MAX(D1:F1)>=.5,1,0).

Can this be done?

Cordially,

Noonien
Reply With Quote
  #2  
Old 12-27-2018, 11:34 AM
Dan Moore's Avatar
Dan Moore Dan Moore is offline
Member
SOA AAA
 
Join Date: Jan 2008
College: University of Dallas
Posts: 2,190
Blog Entries: 1
Default

Max(A1:C1)/Sum(A1:C1). If this expression > 0.5, you know the condition has been reached somewhere within A1:C1.
__________________
The best time to plant an oak tree is twenty years ago. The second best time is right now.
Reply With Quote
  #3  
Old 12-27-2018, 11:38 AM
SlowMotionWalter's Avatar
SlowMotionWalter SlowMotionWalter is offline
Member
CAS
 
Join Date: Jun 2013
Posts: 12,828
Default

=IF(MAX(A1:C1)>SUM(A1:C1)/2,1,0)
__________________
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
  #4  
Old 12-27-2018, 11:49 AM
Noonien Soong Noonien Soong is offline
CAS
 
Join Date: Sep 2018
Posts: 26
Default

I see.
Reply With Quote
  #5  
Old 12-27-2018, 06:34 PM
DeepPurple's Avatar
DeepPurple DeepPurple is offline
Member
 
Join Date: Jun 2004
Posts: 4,247
Default

=countif(a1:c1,">="&.5*sum(a1:c1))
__________________
Come on. Let's go space truckin'. Come on!
Reply With Quote
  #6  
Old 12-27-2018, 06:36 PM
DeepPurple's Avatar
DeepPurple DeepPurple is offline
Member
 
Join Date: Jun 2004
Posts: 4,247
Default

=ROUND(MAX(A1:C1)/SUM(A1:C1),0)


i like this best
__________________
Come on. Let's go space truckin'. Come on!

Last edited by DeepPurple; 12-28-2018 at 03:12 PM..
Reply With Quote
  #7  
Old 12-27-2018, 06:39 PM
Patience's Avatar
Patience Patience is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: a kinder, gentler place
Favorite beer: Scotch
Posts: 48,325
Default

Quote:
Originally Posted by Noonien Soong View Post
Seasons greetings humans,

To make use case simple, say i have numbers in A1:C1. Is there a way to only use cell D1 to see if any of A1, B1, or C1 is greater than 50% of the total of sum A1:C1?

I'm trying to avoid making D1:F1 = A1/sum(A1:C1), B1/sum(A1:C1), and C1/sum(A1:C1), then having to make G1=if(MAX(D1:F1)>=.5,1,0).

Can this be done?

Cordially,

Noonien
Yes
__________________
"I've been through the desert on a horse with no name...
In the desert you can remember your name
'Cause there ain't no one for to give you no pain"
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 11:06 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, 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.32469 seconds with 9 queries