Thread: Divide a # into 3 #'s rounded to a whole #
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CellShocked CellShocked is offline
external usenet poster
  
Posts: 277
Default Divide a # into 3 #'s rounded to a whole #
On Thu, 7 Feb 2013 16:54:26 +0000, TreeHugger1
wrote:


Wow, very easy. Thank you very much for the help.

Paga Mike;1609193 Wrote:
With 17 in A1, In A2 thru A4, enter:

=ROUND(0.15*A1,0)
=ROUND(0.35*A1,0)
=A1-A2-A3

I hope you read the whole thread.
Reply With QuoteReply With Quote