I am looking for a formula that will; look to cell F288 and if the number is between 50 and 499 the result will be 50 If it is outside that range the result will be 0 (zero). Is this possible?