Greater than, less than

[hodkd]

I want to use a table to reference a cell if two other cells meet the
following criteria: less than 2000 in one cell and greater than 75 and
less than 86 in another cell. Such as:

=IF(AND)(F20<2000,H20>75&<86),D8," ")

File Attached: http://www.exceltip.com/forum/attachment.php?postid=288975 (braking template calculatort.xls)

 

[Biff]

Hi hodkd,

Try this:

=IF(AND(F20<2000,H20>75,H20<86),D8,"")

Biff

-----Original Message-----
I want to use a table to reference a cell if two other cells meet the
following criteria: less than 2000 in one cell and greater than 75 and
less than 86 in another cell. Such as:

=IF(AND)(F20<2000,H20>75&<86),D8," ")

File Attached:

http://www.exceltip.com/forum/attachment.php?postid=288975
(braking template calculatort.xls)

------------------------------------------------
[/url]
~~ View and post usenet messages directly from http://www.ExcelForum.com/

.

 

[J.E. McGimpsey]

One way:

=IF(AND(F20<2000, H20>75, H20<86),D8,"")

Note I used the null string ("") rather than a space as you had.

 

[hodkd]

Thanks that does work. If you look at my attahced spread sheet you will
see I have several variables on the left and on the top. I would like
to combine all of those variables in one formula, such as
=IF(AND(F20<2001,H20<76),C8,"")+IF(AND(F20<2001,H20>75,H20<86,D8,"")...on
through the top variables and then start on the next varible on the
left, such as
=IF(AND(F20>2000,F20<4001,H20<76),C9,"")+IF(AND(F20>2000,F20<4001,H20>75,H20<86),D9,"")...then
repeat with each varialbe on the top and to the left. I see I can get
them to work in individual cells but can they be combined into one
cell?