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

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

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

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

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)?

I cannot explain why anyone would do -1+1. In some (other)
circumstances, perhaps it might convert text to numeric (just a guess);
but that does not seem necessary here. And many people seem put all of
their numeric expressions inside =SUM(...). When I asked this forum
why, I got answers ranging from "it don't hurt, so don't fix it" to
silly rationalizations. The bottom line: only someone who does not
know what they are doing would do either, IMHO. It is good that you
know enough to realize that such expressions are dubious.

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

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