Really?

[xenou]

This formula actually exists in a spreadsheet at my workplace:

=(((((((((((((((((((((((((((((((p4032/o4032)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0

 

[delaneyjm]

the purpose of it? other than to obfuscate a formula as far as I can tell...

 

[Ron Coderre]

This formula actually exists in a spreadsheet at my workplace:

=(((((((((((((((((((((((((((((((p4032/o4032)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0

Um...yeah...that formula is in the "Excel for O.C.D." book.
(That's the short formula version, for when you're in a hurry)

 

[xenou]

Um...yeah...that formula is in the "Excel for O.C.D." book.
(That's the short formula version, for when you're in a hurry)

 

[Jonmo1]

This formula actually exists in a spreadsheet at my workplace:

=(((((((((((((((((((((((((((((((p4032/o4032)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0)+0

What's your boss's email address so I can send my resume ?

 

[litrelord]

Looks to me like someone's been using Paste Special > Add. Is it near some cells that people have used this method to convert text to numbers (copy a blank cell and paste special > add to the range - much quicker than the 'convert to number' option from the smart tag).

 

[xenou]

^^ By jove I think he's got it! That would explain the bizarre formula.

 

[Jon von der Heyden]

Looks to me like someone's been using Paste Special > Add. Is it near some cells that people have used this method to convert text to numbers (copy a blank cell and paste special > add to the range - much quicker than the 'convert to number' option from the smart tag).

Well spotted Nick!