SOLVED

what if equation

Copper 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)
Solution

@stetson340 I believe that would be:

=MIN(677,IF(I26<0,J26*-I26,0))

@stetson340 

Perhaps

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

could work if J26 is always positive

Thank you very much I believed it work!  @Riny_van_Eekelen 

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@stetson340 I believe that would be:

=MIN(677,IF(I26<0,J26*-I26,0))

View solution in original post