SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

(Solved) - How to pick Best of two values out of three in excel sheet??????

(7 posts)
  • Started 2 years ago by amrinderminhas
  • Latest reply from amrinderminhas
  • Topic Viewed 1281 times

amrinderminhas
Posts: 59

hi all,
A little problem i m facing of applying a formula in Excel

I have 3 values in 3 cells, say in A1=15, in B1=20, in C1=8;
I would like that in D1 cell the formula be applied such that the out of three, the two higher values gets added up.
In above example the output will be 15+20=35

Thanx....

Posted 2 years ago
Top
 
amrinderminhas
Posts: 59

hello kindly provide me wid answer..
requires urgently..
If case is not understood then also do tell....
I would try to make it more clear

Posted 2 years ago
Top
 
nosparks
Posts: 148

how about =SUM(A1:C1)-MIN(A1:C1)

Posted 2 years ago
Top
 
moreeg
Posts: 842

hi nosparks

That will work if there are only 3 numbers in the series but if there are more you might use the "Large" function as in

=LARGE($A$1:$A$3,1)+LARGE($A$1:$A$3,2)

never mind - i see that the question relates to only three values ... no need to use the LARGE function

Accepted Answer · Posted 2 years ago
Top
 
Enthusiast
Posts: 566

amrinderminhas,

Please remember that if your question is not answered right away, it does not mean you are being ignored, it means that someone with the answer has not gotten to your question yet. Sometimes, these things take time.

Posted 2 years ago
Top
 
Xhi
Posts: 6298

...and this is a world wide site. The expert may be sleeping.

Posted 2 years ago
Top
 
amrinderminhas
Posts: 59

THANX TO EVERYBODY, I SEARCHED THE NET ND FOUND LARGE FORMULA ....
BT AGAIN THANX FOR THE HELP AGAIN
GN

Posted 2 years ago
Top
 



Topic Closed

This topic has been closed to new replies.