try this:

=if(sum(b4:b12)100, sum(b4:b12)*1.05,sum(b4:b12)
--
hope to help,
cm


"jmo" wrote:

Hi, i was wondering if you could help me figure out how to make this work.

Senario would be

I need to sum b4:b12, if that sum is greater then $100 then i need it to add
a 5% bouns to the dollar amount else just give me the sum.
--
Jeremy Morton