Not sure how it relates to my question, but here is my best guess at
answering your question (Pete is right though, more details would be helpful):

Number you are testing is in a2
Number you want a2 to be greater than is in cell a3
Number you want a2 to be less than is in cell a4
cell the result is displayed in A5

In cell A5 paste this formula =IF((A2A3)*AND(A2<A4),A3," ") So if a2 is
greater than a3, and less than a4, then a5 will display the number in a3. If
not then a5 will be left blank.

"thrive" wrote:

I am looking for some help. I have a column of numbers lets say
3
4
5
4
6
I know how to do a formula to find out if a number is greater than another
but how do I do a formula to ask if a cell is greater than another but not
less than another and then I also need to have another cell = the greater
amount??
--
thrive


"diaare" wrote:

Could someone please help me figure out what is going on here?

I have the following in a spreadsheet:

Cell BQ16 = 536 - a raw number
Cell BQ17 = 509 - correctly derived from the formula:
(=INDEX(HourlyData!$A$2:$Z$355,MATCH('Efficiency July-Dec
07'!BQ$3,ManpowerData!$A$2:$A$355,0),2)

In Cell BQ18 I have the formula =BQ17/BQ16 formatted as a percent - should
be 95% but it calculates 0%.

When I place this formula in BQ18 =BQ16/BQ17 I get the #DIV/0! error. Why?
I see 509 in BQ17, not zero. Why does excel think it is a zero?

Am I not able to do a calculation using a number in a cell generated by an
index match function? Or is this something else?

Thanks,
Diane