I'm trying to get excel to display the numerical value "000" if an associated cell has the text value of "CLR". An example of my workbook:
Cell F5 has the numerical value "110". Cell F6 has the text value "CLR". What I want to do is this: In column G I want the values entered in column F repeated, except that if the text value in F is "CLR", I want the value in column G to say "000". Thank you!
Cell F5 has the numerical value "110". Cell F6 has the text value "CLR". What I want to do is this: In column G I want the values entered in column F repeated, except that if the text value in F is "CLR", I want the value in column G to say "000". Thank you!