what if equation

New Contributor

=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?

3 Replies
best response confirmed by Hans Vogelaar (MVP)

@stetson340 I believe that would be:




=MIN(677, MAX(I26*-J26,0) )

could work if J26 is always positive

Thank you very much I believed it work!  @Riny_van_Eekelen