Posted by Rob on March 02, 2001 1:45 PM
I would like to have a formula search a defined range of cells and return a "Yes" or "No" answer in cell A1. The defined range is from B25:M25. The range includes dates and test scores. For instance, cell B25 will be "3/5/01" and cell C25 will be 65, cell D25 will be "4/5/01" and cell E25 will be 68, and so on down the range... Some of the cells in the range will not have any data in them yet, this will be filled in as time goes on.
Cell A1 will have a "Yes" or "No" answer, if the defined range has a test score of greater then or equal to 70.
I am attempting to use the following formula in cell A1:
=If(B25:M25>=70,"Yes","No"), unfortunately this formula does not always work correctly. I think it is because Excel is interpreting the "dates" as general numbers and is throwing off the formula and providing a "Yes" answer in cell A1 when it should be "No".
Any help would be greatly appreciated.