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

--
HTH

Bob Phillips

"sam74" wrote in message
...
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,