

FlashChat  Actuarial Discussion  Preliminary Exams  CAS/SOA Exams  Cyberchat  Around the World  Suggestions 
DW Simpson 
Actuarial Salary Surveys 
Actuarial Meeting Schedule 
Contact DW Simpson 

Thread Tools  Search this Thread  Display Modes 
#1




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 
#5




=countif(a1:c1,">="&.5*sum(a1:c1))
__________________
Come on. Let's go space truckin'. Come on! 
#6




=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; 12282018 at 03:12 PM.. 
#7




Quote:
__________________
"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" 
Thread Tools  Search this Thread 
Display Modes  

