specific conditional formatting
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Forum home » Delegate support and help forum » » Specific conditional formatting

# Specific conditional formatting

Resolved · Medium Priority · Version 2003

Mon 2 Nov 2009, 11:48Delegate Paul said...

Paul has attended:
Excel Intermediate course

### 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.

For upcoming training course dates see:

Mon 2 Nov 2009, 13:13Trainer Amanda said...

### RE: specific conditional formatting

Hello Paul

Thank you for your question, and we're glad to hear you found the course useful.

I've attached an example of how I think you could make this work (based on my understanding of your post). What I would suggest would be to have a separate column that works out the deduction if the scan description is a PET or PET/CT, then you can hide this column if you like but the total will still take account of the deductions. I haven't hidden the column in the attached example so that you can see the formula easily.

I hope this helps.

Kind regards
Amanda

### Attached files...

Mon 2 Nov 2009, 13:52Delegate Paul said...

### RE: specific conditional formatting

Thank you very much

### Excel articles

excel+courses+in+london and other Microsoft training courses.

### Generating simple column charts

1.Select cell range containing data/figures
2. Press F11

View all Excel hints and tips

MS Project training
 Course rating: 4.8 stars - based on 5149 reviews