Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
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
| Check out our Excel Resources
|
 |
 |
Re: 21 = 6+5+4+3+2+1. Help : )
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)
Re: 21 = 6+5+4+3+2+1. Help : )
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
Re: 21 = 6+5+4+3+2+1. Oops wrong post
Posted by Faster on February 01, 2001 2:59 PM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.