Thread Tools Rate Thread

# greater than or less than if statements

=?Utf-8?B?RVJH?=
Guest
Posts: n/a

 25th Jan 2006
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.

SteveG
Guest
Posts: n/a

 25th Jan 2006

=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

Bob Phillips
Guest
Posts: n/a

 25th Jan 2006
=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:(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.

=?Utf-8?B?SlRC?=
Guest
Posts: n/a

 25th Jan 2006

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

=?Utf-8?B?SlRC?=
Guest
Posts: n/a

 25th Jan 2006
=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.

=?Utf-8?B?T0RNVg==?=
Guest
Posts: n/a

 25th Jan 2006
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.

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Jason Microsoft Excel Misc 2 5th Apr 2010 06:11 PM charlie Microsoft Excel Worksheet Functions 5 26th Jun 2009 08:28 PM Sisilla Microsoft Excel Programming 12 6th Oct 2006 08:04 PM Geezer Microsoft Excel Programming 5 18th Mar 2005 12:45 PM Dave B Microsoft Access Getting Started 2 22nd Feb 2004 10:30 AM

Features

Advertising

Newsgroups

All times are GMT +1. The time now is 05:51 AM.