# greater than or less than if statements

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Jan 25, 2006.

1. ### GuestGuest

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.

Guest, Jan 25, 2006

2. ### SteveGGuest

SteveG, Jan 25, 2006

3. ### Bob PhillipsGuest

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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

Bob Phillips, Jan 25, 2006
4. ### GuestGuest

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

Guest, Jan 25, 2006
5. ### GuestGuest

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

Guest, Jan 25, 2006
6. ### GuestGuest

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.

Guest, Jan 25, 2006

## Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.