Mar 10 2022 09:00 AM
=IF(I26<0,J26*-I26,0) is the equation that I have now. This equation allows the cell value to go up and down as other cells change. For this problem, I wish the cell to stop at $677 because that is the max value that I want. How can I do this?
Mar 10 2022 11:50 AM
Mar 10 2022 12:53 PM
Thank you very much I believed it work! @Riny_van_Eekelen
Mar 10 2022 10:14 AM
Solution