Forum Discussion
I need to divide by a cell only if another cell contains text.
In order for anybody to help you, you're going to have to be both more clear and more complete.
For example, you mention that cell C2 contains a number that you want to "divide by," but you also describe a cell that is roaming around in column K of sheet 2 as the cell you want to "divide by." I'm assuming you really mean that cell C2 is the number to be divided, and it is to be divided by that number roaming around in column K of sheet 2.
Then there's the matter of John Smith who might be locked up in a cell of his own, but occasionally let out to be replaced by John Doe (?) in which case the row in column K will change (?)
You see the problem?
More clarity, please; more thoroughness, please. Ideally, post a copy of this workbook on OneDrive or GoogleDrive and paste a link here that grants access. But only if you can also supply a better description of what's going on.