» Calculating Net Sale Price According to Text Criteria

Problem:

Columns A & B contain the full price of various items along with a matching category.
The letter "D" in the category name indicates a 20% discount on the full price for that item.
We want to create a formula that calculates the appropriate sales price for each item.
Solution:

Use the IF, ISERROR, and FIND functions in the following formula:
=IF(ISERROR(FIND("D",B2)),A2,80%*A2)