Hi Sam,

This is Raju from India. I am working as a Installation Engineer in Solivar
Software.

Here is your Formula. Target Cell: H4 as you mentioned:

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

Thanks
Raju
"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,