Help with Excel Invoice

[julius2017]

Hello all,
I just registered to this forum, because i need some help with one excel invoice. I know this might be a stupid question/easy question, but anyway, here it is:

if E5 contains the text "today", then E4 should contains number "256"

if E5 contains the text "tomorrow", then E4 should contains number "100"

if E5 contains the text "airplaine", then E4 should contains number "99"


Let's say that
256 = M10
100 = M11
99 = M12


I hope i made myself understood 😏
Thank you in advance.

[Pete_UK]

This is a duplicate thread - you can find a possible answer in your other thread, so don't use this one.

Pete

[Richard Buttrey]

Hi and welcome to the forum

Please Login or Register  to view this content.

[Richard Buttrey]

Thanks Pete. Noted. Thread closed.