I'm missing something here.
I have a range of cells, say C1:C30. If any of the numerical values of the cells in this range is greater than 10, I'd like the formula in cell B1 to post a message that says "Complete". If none of the cells in the range is greater than 10, B1 needs to remain blank. Any ideas ?
Thanks in advance.
I have a range of cells, say C1:C30. If any of the numerical values of the cells in this range is greater than 10, I'd like the formula in cell B1 to post a message that says "Complete". If none of the cells in the range is greater than 10, B1 needs to remain blank. Any ideas ?
Thanks in advance.