Greater than, less than

J

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

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?
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top