Thread: can you nested sum and round function within if function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
anna
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote