Greater Than but Less than
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!
|