I want to multiply B1*140 if A1 has the letter A in it, or B1*170 if A1 has the letter B in it, or B1*200 if A1 has the letter C in it. For example A1 might have "C4" so B1 should be multiplied by 200. So what is a formula that will disregard the number in A1 and only search for "A", "B", or "C" while multiplying B1 with the right number? Thanks for being nice by reading my post!
Bookmarks