software

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(D10gt;B20,D10lt;(B20 1)),B10,B20)

Cheers,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=504895=IF(AND(D10gt;B20,D10lt;B20 1)lt;B10,B20)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;ERGquot; gt; wrote in message
...
gt; How do you make a formula to state if a number is greater than one number
but
gt; less than another number. My example is: if d10 is greater than b20 but
less
gt; than b20 1, then b10, if not, b20.


quot;ERGquot; wrote:

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

=IF((B20 1) gt; D10,B20,D10)quot;ERGquot; wrote:

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

Try =IF(D10lt;B20 1,IF(D10gt;B20,D10,B20),B20)

quot;ERGquot; wrote:

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