Gregg, the formula targets one cell and delivers the result. If other cells also need to be examined and processed the same way, then you will need to copy and edit the formula.

Are you saying that the cell that will be examined is constantly changing position in the worksheet? If so, why? Or do you have several cells that you want to process? Could you provide some more context?