Min and IF formula Not Returning Intended Result

[polsaggie]

I am trying to return a letter in Column N that returns the lowest number as the result. I am currently only able to return the number.

Formula: =MIN(IF((C2-$O$2)/($O$2)>0*(C2-$O$2)/($O$2),(C2-$O$2)/($O$2)),IF((C2-$O$3)/($O$3)>0*(C2-$O$3)/($O$3),(C2-$O$3)/($O$3)),IF((C2-$O$10)/($O$10)>0*(C2-$O$10)/($O$10),(C2-$O$10)/($O$10)))

 

[jasonb75]

MIN is a mathematical function, it can only return a number. If you want to return any text associated with that number then you would need to use other methods. FILTER is the most likely practical option, possibly with MIN or SMALL as a criteria.

You would need to explain the logic of your MIN formula before we attempt anything, the existing syntax looks a bit mixed up and could easily be misinterpreted if we try to break it down.

 

[polsaggie]

I tried the formula below and it seems to work. Thank you!

=INDEX(N:N, MATCH(MAXIFS(O:O, O:O,"<"&C2),O:O,0),1)

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: IF and MIN Formula Not Returning Intended Result
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.