Select lowest value using if fuction
Dear Excel Experts,
I tried to wrote if function for following condition, but could not get expected result.
Condition 1: If value A2 is greater than value B2, then in D2, lowest value should be shown
Condition 2: If value in B2 is greater than value in A2, then in D2, lowest value should be shown.
I have attached herewith the example book for your kind reference.
Please do needful.
Regards
Do you mean?
Formula:
=IF(OR(A2<B2,B2<A2),MIN(A2:B2),"something else")
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.
Dear Fortis,
The code is working properly.
Thank you very much for the help.
Regards,
.........................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks