• 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.

IF and MIN Formula Not Returning Intended Result

polsaggie

New Member
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)))

76936
 
polsaggie
You should reread Forum Rules
There are clear sentences about Cross-Posting.
Ps Same kind of rules are everywhere.
 
Hi, not sure on what version you are, but maybe you need to confirm this formula with CONTROL + SHIFT + ENTER? If you are on newer versions try using MINIFS instead.
 
Back
Top