If cell value is less than or equal to, OR greater than or equal to

Good afternoon,

I'm trying to get a cell to display either "HIT" or "MISS" based on the value of another cell.

So, I currently have A8 set as;

Please Login or Register  to view this content.

This is the difference in days between two dates

I would like to set B8 to be the HIT or MISS cell.

HIT should be displayed when the value of A8 is within -7 to 7

MISS should be displayed when the value is greater than or equal to -8 ... OR .... greater than or equal to 8

So basically, I have a seven day window either side of the target date for the value to show HIT - anything outside of the target window needs to show MISS

Any assistance would be very gratefully appreciated

Brilliant .. thank you for the swift response

Hmmm .. If I don't have a date yet for the formula to calculate from, HIT is constantly displayed.

Is there anything that can be added to keep the cell blank until a date is added into AE8 ?

Originally Posted by Pacific_Quest

Hmmm .. If I don't have a date yet for the formula to calculate from, HIT is constantly displayed.

Is there anything that can be added to keep the cell blank until a date is added into AE8 ?

You can include this:

=IF(A8="","",formula)

Where formula is whatever formula you have already (not including the "=" in the beginning).

Hi 63falcondude,

I'm trying this, but I keep getting error's;

Please Login or Register  to view this content.

Fixed it

Please Login or Register  to view this content.