Using greater than and lesser than formula

[JGW]

I need a formula that will put the resulting quantity in one cell if lesser
than, in another cell if greater than. Example. If the qty in cell J32 is
less than 167, print that result (J32) in cell M32. If the qty in J32 is
more than 166, print the result (J32) in cell L32.

 

[Sean Timmons]

Just use 2 formulas.

in M32, =if(J32<167,J32,"")

in N32, =if(J32>166,J32,"")

 

[JoeU2004]

I need a formula that will put the resulting quantity in one cell if lesser
than, in another cell if greater than. Example. If the qty in cell J32 is
less than 167, print that result (J32) in cell M32. If the qty in J32 is
more than 166, print the result (J32) in cell L32.

In M32:

=if(J32<167,J32,"")

In L32:

=if(J32>166,J32,"")

But if you intend the results to be mutually exclusive, I would write in
L32:

=if(J32>=167,J32,"")

Also, be aware that testing J32 in this manner tests the actual value, which
might differ from the displayed number. You might want to change J32 to
ROUND(J32,0) in both cases, at least where you compare with 166 or 167.