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 |
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) |