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.

=IF(AND(D10>B20,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

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"ERG" <(E-Mail Removed)> wrote in message
news:6CEE445E-FC29-4557-9CAA-(E-Mail Removed)...
> 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.

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

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

Try =IF(D10<B20+1,IF(D10>B20,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.