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!

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

Dave
--
Brevity is the soul of wit.


"KaraGilsdorf" wrote:

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!

We'll say that x = Cell E1

=IF(OR(E1<0.96,E11.05),"MISS","HIT")



KaraGilsdorf wrote:
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!

Try this:

=IF(OR(A1<0.95,A11.05),"MISS","HIT")
--
HTH,

RD

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

"KaraGilsdorf" wrote in message
...
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!

With your *x* number in A1 try:

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

--
HTH

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


with @tiscali.co.uk


"KaraGilsdorf" wrote in message
...
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!

Hi Kara,

Perhaps this helps, with x in cell A1

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

HTH,
--
Kevin James.
Tua'r Goleuni


"KaraGilsdorf" wrote in message
...
| 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!