SUMIF with checkbox condition

David Stokes

I need help writing a formula to apply a mark-up percentage if the checkbox is applied.

Annual revenue is sum of date range. If checkbox is activated, then 1.5% is added to the sum. If no checkbox is present, then it is just the sum of the date range.

thanks for any help.

Leibel S

@David Stokes

=IF([Tech Fee]@row = 1, SUM([8/23]@row:[12/23]@row) * 1.015, SUM([8/23]@row:[12/23]@row))

Leibel S

@David Stokes

=IF([Tech Fee]@row = 1, SUM([8/23]@row:[12/23]@row) * 1.015, SUM([8/23]@row:[12/23]@row))

David Stokes

Thank You!