Thread: greater than or less than if statements
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ODMV
 
Posts: n/a
Default greater than or less than if statements
Try =IF(D10<B20+1,IF(D10B20,D10,B20),B20)

"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.
Reply With QuoteReply With Quote