Discussion Formulas that compare data in other cells in Excel
https://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2708709#M112378
<P>Hello, </P><P>I am trying to write a formula for a cell that will compare data from other cells resulting in the lowest amount in the target cell. Here's what I need: if F24 is less than C14, J14 and E18 then the result should be F24. If any of the values are lower than F24 then the value in that cell should be the result. </P><P>Here's what I have:</P><P>=IF(F24<C14,F24,IF(F24>C14,C14,IF(F24<J14,F24,IF(F24>J14,J14,IF(F24<E18,F24,IF(F24>E18,E18))))))</P><P>It seems to work for the comparison between F24 and C14 but not for the other fields. I should also mention that each of these fields have basic math calculations in them and some are dependent on drop downs (not sure if any of that should make a difference).</P><P> </P><P>Any help is appreciated!</P>Wed, 01 Sep 2021 18:33:33 GMTgpecoraro2021-09-01T18:33:33ZFormulas that compare data in other cells
https://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2708709#M112378
<P>Hello, </P><P>I am trying to write a formula for a cell that will compare data from other cells resulting in the lowest amount in the target cell. Here's what I need: if F24 is less than C14, J14 and E18 then the result should be F24. If any of the values are lower than F24 then the value in that cell should be the result. </P><P>Here's what I have:</P><P>=IF(F24<C14,F24,IF(F24>C14,C14,IF(F24<J14,F24,IF(F24>J14,J14,IF(F24<E18,F24,IF(F24>E18,E18))))))</P><P>It seems to work for the comparison between F24 and C14 but not for the other fields. I should also mention that each of these fields have basic math calculations in them and some are dependent on drop downs (not sure if any of that should make a difference).</P><P> </P><P>Any help is appreciated!</P>Wed, 01 Sep 2021 18:33:33 GMThttps://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2708709#M112378gpecoraro2021-09-01T18:33:33ZRe: Formulas that compare data in other cells
https://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2708882#M112384
<P><LI-USER uid="1143799"></LI-USER> </P><P> </P><P><STRONG>=MIN(F24,C14,J14,E18)</STRONG> is a formula that will deliver the lowest of the four cells referenced.</P><P> </P><P>It took quite a bit of hunting to find the cell in which your formula resided. If I may suggest, if you come back looking for help, it helps others help you if the spreadsheet you attach--thank you for doing that--somehow highlights where the difficulty resides AND if some other representative data has been filled in to work with.</P>Wed, 01 Sep 2021 19:08:54 GMThttps://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2708882#M112384mathetes2021-09-01T19:08:54ZRe: Formulas that compare data in other cells
https://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2715583#M112593
can you share a file that has actual values in it aside from 0.00?<BR />create 3 sheets with different scenarios that depicts real scenariosFri, 03 Sep 2021 06:04:17 GMThttps://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2715583#M112593Yea_So2021-09-03T06:04:17ZRe: Formulas that compare data in other cells
https://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2717629#M112668
<P><LI-USER uid="1047584"></LI-USER> I have entered some values and created 3 different sheets. The solution from <LI-USER uid="425987"></LI-USER> seemed to help except when I select No from one of the drop-downs (hi-lighted in <FONT color="#FFCC00"><STRONG><U>yellow</U></STRONG></FONT>) I get a false response.</P><P> </P><P>Thanks</P>Fri, 03 Sep 2021 15:21:39 GMThttps://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2717629#M112668gpecoraro2021-09-03T15:21:39ZRe: Formulas that compare data in other cells
https://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2717689#M112671
So what do the "Yes" or "No" responses have to do with the cells that were evaluated by your original or my use of MIN? Obviously the "No" affects one or more of the values that are evaluated. YOU are the one who knows the interrelationships involved.Fri, 03 Sep 2021 15:36:01 GMThttps://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2717689#M112671mathetes2021-09-03T15:36:01ZRe: Formulas that compare data in other cells
https://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2717746#M112672
is the No scenario reflected in your shared workbook which also reflects the expected result?Fri, 03 Sep 2021 15:48:50 GMThttps://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2717746#M112672Yea_So2021-09-03T15:48:50ZRe: Formulas that compare data in other cells
https://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2718618#M112694
<P><LI-USER uid="1143799"></LI-USER> </P><P> </P><P>OK, tell you what. You highlighted the cells in <STRONG><FONT color="#FFFF00">yellow</FONT></STRONG> where "Yes" or "No" was requested, which, when entered, caused the cell about which you originally asked your question to not perform as desired. But when I trace back the cells that your original formula referenced (and highlighted them in <FONT color="#339966"><STRONG>green background</STRONG></FONT>) it turns out that some of them aren't even visible under all circumstances!!!!!!!!!!</P><P> </P><P>And they don't all themselves yield numbers as values, so we're looking for a minimum number (by your original request) from a group of cells that don't always show numbers.</P><P> </P><P>May I suggest you go back to the start and create a much more intelligible worksheet? If, at any rate, you want help. This is like an amusement park game where you're aiming at things in the dark. You may know what all the cryptic or non-existent labels mean, but the rest of us are not mind-readers so can't get behind them.</P><P> </P><P>You clearly know how to write Excel formulas; what you need is some help in laying out a spreadsheet so that it makes sense, so that the various dependencies of one cell on another are evident and reasonable. As it is, it would appear that you yourself are having difficulty making sense of it, and it's not because you don't know how to write Excel formulas.</P>Fri, 03 Sep 2021 20:22:29 GMThttps://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2718618#M112694mathetes2021-09-03T20:22:29ZRe: Formulas that compare data in other cells
https://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2718633#M112696
OK. Thanks for your input.Fri, 03 Sep 2021 20:24:31 GMThttps://techcommunity.microsoft.com/t5/excel/formulas-that-compare-data-in-other-cells/m-p/2718633#M112696gpecoraro2021-09-03T20:24:31Z