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

The author of the workbook you received is a pervert.

:-)

--
AP

a écrit dans le message de news:
...
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