| 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
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 |
|
#4
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 |
|
#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 | |||
Hybrid Mode
