IF Statement

[jmo]

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.

 

[cm]

try this:

=if(sum(b4:b12)>100, sum(b4:b12)*1.05,sum(b4:b12)

 

[cm]

sorry I left of the ending parenthesis:

=if(sum(b4:b12)>100, sum(b4:b12)*1.05,sum(b4:b12))

 

[jmo]

perfect...thanks for the help...

 

[T. Valko]

One way:

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

 

[David Biddulph]

=SUM(B4:B12)*(1+(SUM(B4:B12)>100)*5%)