View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default in a cell what is formula to make the numbers 1,2,3,4 = 8

Odd question...

=SUM(-1+2+3+4) equals 8


Why choose that instead of this?

=SUM(1+2*3+4^0)

<g

I think the OP needs to re-ask his question and using more words and all
that white space that comes free with his messages.

By the way, I would note that the SUM function call is not necessary for
either of our formulas.

Rick