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