OR & IF Functions Together

[sam74]

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(F4>5,Z10,Z9))

Any help would be appreciated

Thanks,

 

[Bob Phillips]

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

 

[garfield-n-odie]

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

 

[Raju Boine.]

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