One way:

=IF(SUM(B4:B12)100,SUM(B4:B12)*1.05,SUM(B4:B12))

--
Biff
Microsoft Excel MVP


"jmo" wrote in message
...
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