I want to display a cell on row 3 when a second cell in row 3 is within a
certain range. for example, i want to dis play A3 when B3 is greater than 4
and less than 8.

"Mike H" wrote:

Corey,

Perhaps you could express in words what your trying to do because this bit
of your formula doesn't really make sense.

=IF(39752=Sheet2!D3=39722

Mike

"Corey" wrote:

Why does this function not work?

=IF(39752=Sheet2!D3=39722,Sheet2!A3,0)