RIGHT Function nested inside of IF

Hello,
I am having a little trouble with an =IF statement. My formula is

Formula:

Please Login or Register  to view this content.

But 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.

I tried looking at this post from last year, but can't grasp the concept behind it. Thanks, Jake

http://www.excelforum.com/excel-gene...in-a-cell.html

change your code with this one

Please Login or Register  to view this content.

Originally Posted by jakeisbill

That works beautifully. Could I wrap an IFERROR around it to erase the #N/A and #VALUE errors?

since cell E3 has a value, you dont need IfError

=IF(MID(H3,LEN(H3)-1,1)="P",E3*F3,E3)

if E3 has no value, it will return to 0 (null), in my opinion you dont need IfError