Using greater than and lesser than formula
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. -- Julia |
Using greater than and lesser than formula
Just use 2 formulas.
in M32, =if(J32<167,J32,"") in N32, =if(J32166,J32,"") "JGW" wrote: 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. -- Julia |
Using greater than and lesser than formula
"JGW" wrote:
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(J32166,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. |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com