Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Greater Than but Less than
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching Values from an Array | Excel Worksheet Functions | |||
I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
if greater then 99 then 1 if greater then 199 then two | Excel Worksheet Functions |