MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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