I'm working on a spread sheet and I need help adding onto a IF function to find a specific word in a text in another column to change a value whenever that word apears. Example below, please help!!!!
***The word I need the function to recognize is DMV to change the value in the adjacent cell to 0.00. while other cells in the same column of the 17.00 that do not have that key word to have their value remain unchanged. the cell for 17.00 has an IF formula in the cell already. Hope this helps!
CK-CHK*DMV-CITY*ERR CORR $17.00
Bookmarks