View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joseph Weber
 
Posts: n/a
Default excel function reduce and increase numbers

I need to find out a formula that increases one number when the other
decreases, but does not decrease the number when the other increases.
example
cell A1=30 B1=40
NEXT
cell A1=31 B1=39
but not when there is an increase
cell A1=31 B1=42