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.