Greater Than but Less than

[KaraGilsdorf]

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!

 

[Dave F]

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

Dave

 

[willwonka]

We'll say that x = Cell E1

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

 

[RagDyer]

Try this:

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

 

[Sandy Mann]

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

[email protected]
[email protected] with @tiscali.co.uk

 

[Kevin James]

Hi Kara,

Perhaps this helps, with x in cell A1

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

HTH,
--
Kevin James.
Tua'r Goleuni


| 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!