Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
If statement or lookup statement not sure | Excel Worksheet Functions | |||
SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |