View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JGW JGW is offline
external usenet poster
 
Posts: 2
Default 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