Forum Discussion
If a cell contains a word than another cell is divided by 10
Hello, I am trying to find a way to create a formula that will automatically divide a number contained in a cell by ten. Example: A1 contains one of a series of text such as Large-bob, Medium-bo...
=IF(AND(COUNTIF(A1,"*-bob*"),MOD(B1,10)=0),B1/10,B1)Maybe this formula does what you are looking for. The formula checks if the string in column A contains "-bob" and if the number in column B is a multiple of 10. If true the number in column B is divided by 10 otherwise the number in column B is returned.
Awesome, thank you so much.