Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lesser than, greater than | Excel Discussion (Misc queries) | |||
greater/lesser than | Excel Worksheet Functions | |||
putting a number that is greater or lesser into different cell . | Excel Worksheet Functions | |||
greater than or lesser than formulas | Excel Discussion (Misc queries) | |||
if greater or lesser than | Excel Discussion (Misc queries) |