Aug 24 2020 01:41 PM
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
Aug 24 2020 02:16 PM
Aug 24 2020 02:35 PM
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"?
Aug 24 2020 02:49 PM
Aug 24 2020 02:52 PM
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.
Aug 24 2020 03:05 PM
SolutionAug 24 2020 03:05 PM
Solution