Specific conditional formatting

Hello,

I talked to Simon about this last Thursday but thought I'd put my specific question to the forum.

I work for a medical diagnostic scanning company and work with an invoice log. We have specific scanning fees based on type of scan and number of body areas. We also have a team of doctors who report on our scans and receive a fee for each scan reported.

In most cases the fee is a simple 20% of the total scanning fee (for MRI's, XRAY's etc). However, for PET and PET/CT scans we have to deduct £340 before calculating the 20%.

We have a column in our invoice logs for scanning fees but are having to work out the PET and PET/CT report fees separately as we haven't been able to come up with the correct conditional formatting formula which will automatically calculate the additional £340 deduction.

I know this is going to be an =IF calculation and the logical test is "PET" or "PET/CT" but after that I'm coming unstuck.

Can you come up with a formula for me?

Many many thanks!!!

Great course, by the way - I want to enrol for the advanced class some time soon.