OR & IF Functions Together
 

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,

=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,

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,

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,