| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Greater Than but Less than
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! |
| 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 | |||
Threaded Mode
