greater than or less than if statements
 

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.

greater than or less than if statements
 

=IF(AND(D10B20,D10<(B20+1)),B10,B20)

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=504895

greater than or less than if statements
 

=IF(AND(D10B20,D10<B20+1)<B10,B20)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"ERG" wrote in message
...
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.

greater than or less than if statements
 

"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.

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.

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.