can you nested  sum and round function within if function? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
anna 5/26/2006 5:50 PM PST
  Question
  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
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Don Guillett 5/26/2006 5:59 PM PST
   
  why not just use the round to start with?

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"anna" <anna@discussions.microsoft.com> wrote in message
news:15B6A4CD-98CF-42B7-BBED-62ADE041841E@microsoft.com...
> 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


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
anna 5/26/2006 7:22 PM PST
   
  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
> dguillett1@austin.rr.com
> "anna" <anna@discussions.microsoft.com> wrote in message
> news:15B6A4CD-98CF-42B7-BBED-62ADE041841E@microsoft.com...
> > 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
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Harlan Grove 5/26/2006 9:53 PM PST
  Answer
  anna wrote...
>ypu mean decrese decimal places on the first plaece?
>
>"Don Guillett" wrote:
>>why not just use the round to start with?
....
>>"anna" <anna@discussions.microsoft.com> 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.

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
anna 5/26/2006 10:05 PM PST
   
  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" <anna@discussions.microsoft.com> 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.
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies