Forum Discussion
Formulas that compare data in other cells
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 ...
=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.