I am having a little trouble with an =IF statement. My formula isBut it doesn't acknowledge the Wildcard. Is there a different way of doing this. The end goal is If the 2nd to last character in a string is "P", then E3*F3, else E3.Formula:Please Login or Register to view this content.
I tried looking at this post from last year, but can't grasp the concept behind it. Thanks, Jake