SEARCH

The How-To Geek Forums Have Migrated to Discourse



Join the Discussion at discuss.howtogeek.com

How-To Geek Forums / Microsoft Office

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

(7 posts)
  • Started 8 months ago by amrinderminhas
  • Latest reply from amrinderminhas
  • Topic Viewed 681 times

  • View Accepted Answer
  • Remove Solved Status
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 8 months 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 8 months ago #
Top
 
nosparks
Posts: 148

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

Posted 8 months 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 8 months 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 8 months ago #
Top
 
Xhi
Xhi
Posts: 6298

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

Posted 8 months 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 8 months ago #
Top
 



Topic Closed

This topic has been closed to new replies. Please create a new topic instead.


Create New Topic Return to Forum