Is there a formula in 2003 I could use that let's me perform a different equation if a cell contains a certain letter? eg:
"3400A"
"3400B"
Is there a way to use the IF function to say "If cell contains letter "B", multiply it by "reference cell", if not, just leave it. ?
"3400A"
"3400B"
Is there a way to use the IF function to say "If cell contains letter "B", multiply it by "reference cell", if not, just leave it. ?