IF Advanced

[RalphJHart]

Spreadsheet contains 7 columns of sales data. One row for each sale invoice. Column F contains invoice information, starting with the invoice number. The invoice numbers with a "W" indicate a Warrantee item. We need a formula to indicate when the invoice number contains a "W' and provide the cost from Column G. Something like "If F3 contains "W" then result equals G3, if not then 0".

I have attached a sample file. 

Thank you

[#2]

@RalphJHart 

In a cell in row 3:

=IF(ISNUMBER(FIND("W",F3)),G3,0)

Fill down.

[#3]

@Hans Vogelaar 

Some of the "F" cells have a "W" other than after the Invoice number. Is there a formula that will look only to the invoice numbers ending in "W"?

[#4]

@RalphJHart 

That would be

=IF(RIGHT(F3)="W",G3,0)

[#5]

@Hans Vogelaar 

I must be missing something. That just gives me a zero.

[#6]

@Hans Vogelaar 

Wait - I got it. The challenge is that is nearly every case the invoice number is followed by other data. The "W" is always the 16th character in the string that always starts on the left side. 

[#7 · Accepted solution]

@RalphJHart 

Then it would be

=IF(MID(F3,16,1)="W",G3,0)