Sep 01 2021 11:33 AM
Hello,
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.
Here's what I have:
=IF(F24<C14,F24,IF(F24>C14,C14,IF(F24<J14,F24,IF(F24>J14,J14,IF(F24<E18,F24,IF(F24>E18,E18))))))
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).
Any help is appreciated!
Sep 01 2021 12:08 PM
=MIN(F24,C14,J14,E18) is a formula that will deliver the lowest of the four cells referenced.
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.
Sep 02 2021 11:04 PM
Sep 03 2021 08:21 AM
Sep 03 2021 08:36 AM
Sep 03 2021 08:48 AM
Sep 03 2021 01:22 PM
OK, tell you what. You highlighted the cells in yellow 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 green background) it turns out that some of them aren't even visible under all circumstances!!!!!!!!!!
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.
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.
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.