Thread: divide a total, subtract one then format as a percentage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default divide a total, subtract one then format as a percentage
=(AVERAGE(A1:A100)/SUM(A1:100))-1

" wrote:

i need to create a formula that requires me to divide a total by the average
total, subtract 1 from the result before formatting as a percentage

Reply With QuoteReply With Quote