• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to get one minimum value out of manu

N

nader assaleh

Member
dear
iam trying to let excel give me (choose) one minimum value out of three cells D6:F6 and then
continue further calculation once one minimum value is chosen. attached is the excel sheet
 

Attachments

Hi nader,

Your sheet already had calculations on basis on min value. What exactly are you looking after? Kindly explain more.

Regards,
 
iam trying to replicate manual loadsheet in which if three values (or two values) are same only one is selected and further calculations will be based on that which means select extreme left min value and ignore others.
regards
 
Hi Nader ,

I am not able to understand the logic of what you wish to do ; if we have three values A , B and C , if we wish to use the minimum value of the three , why not do just that ? Work with =MIN(A,B,C) ; you don't need to know whether this minimum value is A or B or C.

Narayan
 
Hi,

There are some issues, the formulas are not consistent. If you can remove formulas from your sheet and just put values with the logic, may be somebody can help you.

Regards,
 
Hi, nader assaleh!
Maybe you want to share your solution with the community, so as people who read this would have the issue or question and the solution or answer as well.
Regards!
 
You must log in or register to reply here.
Back
Top