if h2 > 30 and h2

if h2 > 30 and h2 < 60

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tom - 19 Jun 2007 20:07 GMT

How to do the following conditional:

if h2 > 30 and h2 < 60

Reply to this Message

Don Guillett - 19 Jun 2007 20:24 GMT

formula/macro?

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> How to do the following conditional:
>
> if h2 > 30 and h2 < 60

Reply to this Message

Ian - 19 Jun 2007 20:31 GMT

Format>Conditional formatting>Cell value is>between>30>60 assuming 30 and 60
need to satisfy the condition. The set the format you want.

Signature

Ian
--

> How to do the following conditional:
>
> if h2 > 30 and h2 < 60

Reply to this Message

Piscator - 19 Jun 2007 20:55 GMT

=IF(H2>30,IF(H2<60,"TRUE","FALSE"),"FALSE")

Reply to this Message

Earl Kiosterud - 19 Jun 2007 21:08 GMT

Tom,

Your question is vague, but here's something:

=IF( AND(H2>30, H2<60), "It's between 30 and 60", "It ain't" )

Signature

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

> How to do the following conditional:
>
> if h2 > 30 and h2 < 60

Reply to this Message