IF Statement
 

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

IF Statement
 

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

IF Statement
 

sorry I left of the ending parenthesis:

=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

IF Statement
 

perfect...thanks for the help...
--
Jeremy Morton


"cm" wrote:

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

IF Statement
 

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

IF Statement
 

=SUM(B4:B12)*(1+(SUM(B4:B12)100)*5%)
--
David Biddulph

"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