View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JTB
 
Posts: n/a
Default greater than or less than if statements

=IF((B20 + 1) D10,B20,D10)


"ERG" wrote:

How do you make a formula to state if a number is greater than one number but
less than another number. My example is: if d10 is greater than b20 but less
than b20+1, then b10, if not, b20.