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

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

using =sum() to get a percentage
 

the +1 and -1 cancel each other out... so... no reason...


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553690

using =sum() to get a percentage
 

I guess whoever created the formula was just throwing things out there to see
what sticks. Sum isn't needed and -1 +1 would cancel out. I would probably
change it to something like =if(a2 = 0, 0, a1/a2)
--
Kevin Vaughn


" wrote:

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

using =sum() to get a percentage
 

using =sum() to get a percentage
 

No reason, total overkill.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

wrote in message
ups.com...
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

using =sum() to get a percentage
 

Tad harsh don't you think?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Ardus Petus" wrote in message
...
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