Greater Than but Less than

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KaraGilsdorf - 18 Oct 2006 19:40 GMT

I've been working on this formula for hours and I'm not coming up with
anything that works!

I need a formula that will calculate the following:

If x is less than .95 OR greater than 1.05, cell will read MISS
If x is greater than or equal to .95 but less than or equal to 1.05, cell
will read HIT

Someone please help! I get something that I think works and it doesn't!

Thanks!

Reply to this Message

Dave F - 18 Oct 2006 19:46 GMT

=IF(OR(X1<.95,X1>1,05),"MISS",IF(OR(X1>=.95,X1<=1.05),"HIT",""))

Dave

Signature

Brevity is the soul of wit.

> I've been working on this formula for hours and I'm not coming up with
> anything that works!
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

willwonka - 18 Oct 2006 19:48 GMT

We'll say that x = Cell E1

=IF(OR(E1<0.96,E1>1.05),"MISS","HIT")

> I've been working on this formula for hours and I'm not coming up with
> anything that works!
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

RagDyer - 18 Oct 2006 19:56 GMT

Try this:

=IF(OR(A1<0.95,A1>1.05),"MISS","HIT")

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> I've been working on this formula for hours and I'm not coming up with
> anything that works!
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

Sandy Mann - 18 Oct 2006 19:59 GMT

With your *x* number in A1 try:

=IF(ABS(100-A1)>5,"Miss","Hit")

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> I've been working on this formula for hours and I'm not coming up with
> anything that works!
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

Kevin James - 18 Oct 2006 20:42 GMT

Hi Kara,

Perhaps this helps, with x in cell A1

=IF((ABS(A1-1)>0.05),"MISS","HIT")

HTH,

Signature

Kevin James.
Tua'r Goleuni

| I've been working on this formula for hours and I'm not coming up with
| anything that works!
[quoted text clipped - 8 lines]
|
| Thanks!

Reply to this Message