Thread: Make last digit always display the same value.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Make last digit always display the same value.
On Fri, 13 Apr 2007 21:35:04 -0400, "T. Valko" wrote:

=IF(SUM(A1:A10),CEILING(SUM(A1:A10)+0.01,0.1)-0.01,"")

I would point out that your function will return a NULL string if there are no
entries in the range; and will also return a NULL string if the SUM of the
entries is zero.

That may or may not be appropriate for this poster.
--ron
Reply With QuoteReply With Quote