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

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

amrinderminhas
Posts: 0

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 5 years ago

amrinderminhas
Posts: 0

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 5 years ago

nosparks
Posts: 0

Posted 5 years ago

moreeg
Posts: 0

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 5 years ago

Enthusiast
Posts: 0

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 5 years ago

Xhi
Posts: 0

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

Posted 5 years ago

amrinderminhas
Posts: 0

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

Posted 5 years ago

## Topic Closed

This topic has been closed to new replies.