Simple "IF" Formula help

[south0085]

Thank you for your time. I need help with, what should be, a simple formula. But for some reason, I can't figure it out today. My formula is in cell E13. I want the formula to do this:

If, in cell D13, the farthest right character is an "S",

then, return everything that's to the left of that "S",

If it does not end with an "S",

then, simply return the entire content of D13.

Thank you!

 

[Jonmo1]

Try

=IF(RIGHT(D13)="S",LEFT(D13,LEN(D13)-1),D13)

or

=LEFT(D13,LEN(D13)-(RIGHT(D13)="S"))

 

[Roxxien]

Hello,

E13=IF(RIGHT(D13,1)="s",LEFT(D13,LEN(D13)-1),D13)

You are welcome.

 

[south0085]

Try

=IF(RIGHT(D13)="S",LEFT(D13,LEN(D13)-1),D13)

or

=LEFT(D13,LEN(D13)-(RIGHT(D13)="S"))

Crap, it was the "-1". That's the part I couldn't figure out. Thank you for helping me.

I do have another question, if you don't mind. I need a formula like this, but I need it to return a blank value or a zero if it's false, rather than "false"

If A13="RESIN", or if A13="Parts", or if A13="Package", then do: vlookup(E13,Y:Z,2,false)

If false, return a blank or "0".

 

[Jonmo1]

Try

=IF(OR(A13={"RESIN","Parts","Package"}),vlookup(E13,Y:Z,2,false),"")

 

[south0085]

Thank you! Perfect.

 

[Jonmo1]

You're welcome.