View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default using =sum() to get a percentage

I recently received a spreadsheet that contained =sum(a1/a2)-1+1. The
cell containing the formula was formatted to percentage. I was
wondering why use =sum()-1+1 when +a1/a2 would render the same result
(provided the cell is formatted to percentage)? Thank you