Formula with minimum & maximum values

[Guest]

I am trying to create a formula that will multiple two cells (ex: A8*A9) but
I want to make sure the final value is greater than or equal to zero and less
than or equal to 400. How would I do this? I appreciate your help.

 

[Dana DeLouis]

Hi. One way...
=MIN(MAX(A8*A9,0),400)

 

[T. Valko]

Maybe this:

=IF(AND(A8*A9>=0,A8*A9<=400),A8*A9,"")

Biff

 

[Guest]

=if(or(A8*A9<0,A8*A9>400),"Not in range 0-400",A8*A9)
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.

 

[Guest]

Not sure if my post went through, so I'll try once more -

What do you want the cell to display if it is outside of 0-400? Assuming
you would want 0 or 400 to be displayed when the product is outside that
range, another suggestion:

=MEDIAN(A8*A9,0,400)

 

[Guest]

Thanks to all for your help. I have saved all of the formulas provided as I
am sure they will all be useful.