T
tom
How to do the following conditional:
if h2 > 30 and h2 < 60
if h2 > 30 and h2 < 60
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
formula/macro?
I
Ian
Format>Conditional formatting>Cell value is>between>30>60 assuming 30 and 60
need to satisfy the condition. The set the format you want.
need to satisfy the condition. The set the format you want.
P
Piscator
=IF(H2>30,IF(H2<60,"TRUE","FALSE"),"FALSE")
E
Earl Kiosterud
Tom,
Your question is vague, but here's something:
=IF( AND(H2>30, H2<60), "It's between 30 and 60", "It ain't" )
--
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...
Your question is vague, but here's something:
=IF( AND(H2>30, H2<60), "It's between 30 and 60", "It ain't" )
--
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...