Hi... any one can give formula for my problem?
Here it is:
If Cells contains [ A1= 4 B1=8 C1 = 9 D1=7] Then E1 should reflects the sum of two biggest number
in this example E1=17 (B1+C1)
In this example in cell E1 which formula I should use please help me...
Thanks in Advance.
=if(and(a1=4,b1=8,c1=9),large(a1:c1,1)+large(a1:c1,2))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi deepanc
Put this formula into cell E1:
Regards
=LARGE(A1:D1,1)+LARGE(A1:D1,2)
huuthang
=large(a1:d1,1)+large(a1:d1,2)
HiI really thank 2 all. By your guide I make it simplify as =sum(large{1,2}) thanks once again . I need your hands just like this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks