Assuming that when you say "falls in the range of -8 to +5", you
want the values -8 and +5 to be included in the range, try:

=IF(AND(F4=-8,F4<=5),Z9,Z10)

But if you only want numbers greater than (but not equal to) -8
and values less than (but not equal to) +5, then change the = to
, and the <= to <.

sam74 wrote:

Hi There,

I really need some help on this one. I (think) I have to use both the above
to achieve what I want to do , but just can't get it to work. Here is the
scenario:

Source Cell: F4

This Formula/Target Cell: H4

Reference Cells: Z9 & Z10

Basically what I need is to have H4 take a look at F4 and if it falls in the
range of -8 to +5 then display Z9 otherwise display Z10.

Here is my attempt: =OR(IF(F4<-8,Z10,Z9),IF(F45,Z10,Z9))

Any help would be appreciated

Thanks,