Greater than or less than

[Eric Hedden]

I am trying to do an IF statement that lets me have more
than one arguement. For instance:
=IF(G27>2400,$C$115,0) I wish to have a range. Basically
I want IF(G27<1200 OR G27>2400,$C$115,0). I know that is
incorrect, but how do I do this correctly?

 

[Michael Hopwood]

IF(OR(G27<1200,G27>2400),$C$115,0)

Also, look at the AND() function.

Easy when you know how. <g>

 

[Chicago]

You're almost there

 

[Norman Harker]

Hi Eric!

Try:
=IF(OR(G27<1200,G27>2400),$C$115,0)

The IF conditions must return TRUE or FALSE. You can pre test them on
their own:

=OR(G27<1200,G27>2400)
Returns TRUE or FALSE depending on contents of G27

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Eric H]

Can I have more than one arguement?
Like G27<2401,G27>3600,$C$116 ??

How do I write that?

 

[JE McGimpsey]

Just another way:

=$C$115 * (ABS(G27-1800)>=600)

 

[Norman Harker]

Hi Eric!

Try:
=IF(OR(G27<1200,G27>2400),$C$115,IF(OR(G27<=2400,G27>3600),$C$116,0))

I amended what you asked for to G27<=2400 but you must decide what to
do with the =2400 case.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

IF(OR(G27<1200,G27>2400),$C$115,IF(OR

-----Original Message-----
Can I have more than one arguement?
Like G27<2401,G27>3600,$C$116 ??

How do I write that?

.

 

[Guest]

Thanks to everyone who chimed in. I'm on my way!