Thread: ratio function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] google@magneticnorth.ca is offline
external usenet poster
  
Posts: 10
Default ratio function
perhaps...

=ROUND(H9/SUM(H9:I9)*100,0)&":"&ROUND(I9/SUM(H9:I9)*100,0)

HTHs
Reply With QuoteReply With Quote