Add a correction unless the total has it

Add 0.75 hours to a 38.5-hour total only when the total doesn't already include it.

What you'll make

In Excel: 38.5 + 0.75, not yet included becomes 39.25 hours.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1NOT(ISLOGICAL(C8))Checks that column C isn't TRUE or FALSE.FALSE
2"Review totals inclusion basis"The message when column C isn't TRUE or FALSE.Not used for row 8
3IF(C8,A8,A8+B8)TRUE keeps the total; FALSE adds the correction.39.25
4IF( … )Shows part 2 if part 1 is TRUE, else part 3.39.25

Column C must hold TRUE or FALSE, not yes or no. Corrections can be negative.

=IF(NOT(ISLOGICAL(C8)),"Review totals inclusion basis",IF(C8,A8,A8+B8))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own hours. Paste the source total, the posted correction and TRUE or FALSE into the green columns of the Template tab. The report total fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Check in the source report whether its total already includes the correction. Marking it wrong counts it twice or not at all.

Microsoft's help: IS functions