Formula with minimum & maximum values
 

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.

Formula with minimum & maximum values
 

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

--
HTH :)
Dana DeLouis
Windows XP & Excel 2007


"readystate" wrote in message
...
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.

Formula with minimum & maximum values
 

Maybe this:

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

Biff

"readystate" wrote in message
...
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.

Formula with minimum & maximum values
 

=if(or(A8*A9<0,A8*A9400),"Not in range 0-400",A8*A9)
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"readystate" wrote:

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.

Formula with minimum & maximum values
 

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)



"readystate" wrote:

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.

Formula with minimum & maximum values
 

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

"Dana DeLouis" wrote:

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

--
HTH :)
Dana DeLouis
Windows XP & Excel 2007


"readystate" wrote in message
...
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.