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 1 year 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 1 year 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 1 year ago
Top
 
nosparks
Posts: 148

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

Posted 1 year ago
Top
 
moreeg
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 1 year ago
Top
 
Enthusiast
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 1 year ago
Top
 
Xhi
Xhi
Posts: 6298

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

Posted 1 year 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 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.

Enter Your Email Here to Get Access for Free:

Go check your email!