21 = 6+5+4+3+2+1. Help : )

Posted by Phil Ridley on January 31, 2001 9:44 PM

Hi,
I require a formula or a function that can take an input like "21" and tell me what the highest number is in the set of sequential numbers starting at one that adds up to it (eg 10 = 4+3+2+1).

Thanks in advance

Posted by Kaiowas on February 01, 2001 3:30 AM

(SQRT(8*T+1)-1)/2

Where 'T' is the number you are inputting (called a triangular number)

Posted by Faster on February 01, 2001 12:31 PM

no need to unhide sheet to pass a cell value

MyNum = Sheets("HiddenSheet").Range("E4")
or
Sheets("HiddenSheet").Range("E4") = MyNum

Posted by Faster on February 01, 2001 2:59 PM

Re: 21 = 6+5+4+3+2+1. Oops wrong post

Oops wrong post