If statement or Find statement?

Hi all,

I need help again on an If statement?!?!?!

I am working on contracts (minefield!!) I need it to bring back 100, if the account is out of Warranty but does not begin with Coffee in the account name.

Account Name Warranty Code
Coffee Y
Coffee N
Sugar N 100
Tea N 100

I have attached a spreadsheet for you to play with.

Cheers

Donna