| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can you nested sum and round function within if function?
Can you please tell how to sum one column of data and at the same time round
up or down I tried to use if function If (sum B2:B25) integer, round (sumB2:B25, 0),sum((B2:B25) but it does not work excel does not recognize the text in that case |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can you nested sum and round function within if function?
why not just use the round to start with?
-- Don Guillett SalesAid Software "anna" wrote in message ... Can you please tell how to sum one column of data and at the same time round up or down I tried to use if function If (sum B2:B25) integer, round (sumB2:B25, 0),sum((B2:B25) but it does not work excel does not recognize the text in that case |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can you nested sum and round function within if function?
ypu mean decrese decimal places on the first plaece?
"Don Guillett" wrote: why not just use the round to start with? -- Don Guillett SalesAid Software "anna" wrote in message ... Can you please tell how to sum one column of data and at the same time round up or down I tried to use if function If (sum B2:B25) integer, round (sumB2:B25, 0),sum((B2:B25) but it does not work excel does not recognize the text in that case |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can you nested sum and round function within if function?
anna wrote...
ypu mean decrese decimal places on the first plaece? "Don Guillett" wrote: why not just use the round to start with? .... "anna" wrote in message .... up or down I tried to use if function If (sum B2:B25) integer, round .... I'd guess Don meant why not use =ROUND(SUM(B2:B25),0) which would be the same as SUM(B2:B25) if that sum is a whole number and rounded to the nearest integer otherwise. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can you nested sum and round function within if function?
Thank you very simply and easy
"Harlan Grove" wrote: anna wrote... ypu mean decrese decimal places on the first plaece? "Don Guillett" wrote: why not just use the round to start with? .... "anna" wrote in message .... up or down I tried to use if function If (sum B2:B25) integer, round .... I'd guess Don meant why not use =ROUND(SUM(B2:B25),0) which would be the same as SUM(B2:B25) if that sum is a whole number and rounded to the nearest integer otherwise. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
