• ARTICLES
• SUBSCRIBE
SEARCH

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

(7 posts)
• Started 1 year ago by amrinderminhas
• Topic Viewed 1001 times

• 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 1 year ago #

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 #

nosparks
Posts: 148

Posted 1 year ago #

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 #

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 #

Xhi
Posts: 6298

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

Posted 1 year ago #

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 #

## Topic Closed

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