Started By
Message
locked post

OT math puzzle solvers...

Posted on 6/1/18 at 8:06 am
Posted by NATidefan
Two hours North of Birmingham
Member since Dec 2008
36788 posts
Posted on 6/1/18 at 8:06 am
Ok, so had to figure this one out for work. Didn't take too long and was kinda fun. Reminded me of math riddles I've see on here... So let's see who can figure it out.

I've got a cell in Excel that has variable values. The values are whole numbers that range from 2 to infinity... So... 2,3,4,5,6,7....so on and so on.

Using those variable values and common math formulas I need to be able to generate the following variable values in two separate cells.

Using 2 .... Generate 52 & 53
Using 3 .... Generate 55 & 56
Using 4 .... Generate 58 & 59
Using 5 .... Generate 61 & 62
Using 6 .... Generate 64 & 65
.... And so on and so on.


I'll let ya know if ya find the right formulas.

They don't involve tree fiddy

This post was edited on 6/1/18 at 8:14 am
Posted by Scooba
Member since Jun 2013
20027 posts
Posted on 6/1/18 at 8:08 am to
Posted by Bama and Beer
Baldwin Co, AL
Member since Oct 2010
85815 posts
Posted on 6/1/18 at 8:08 am to
Honestly, it's Friday and at 8am

I don't give a flying frick about math, about work, about anything
Posted by Wtodd
Tampa, FL
Member since Oct 2013
68609 posts
Posted on 6/1/18 at 8:08 am to
K....keep me posted
Posted by brucevilanch
Fort Worth, Tejas
Member since May 2011
24418 posts
Posted on 6/1/18 at 8:08 am to
69
Posted by LZ83
La
Member since Sep 2016
17446 posts
Posted on 6/1/18 at 8:09 am to
I don’t understand the question.
Posted by philly444
stuck in contraflow
Member since Nov 2008
12412 posts
Posted on 6/1/18 at 8:11 am to
288
Posted by Techdog89
Baton Rouge
Member since Dec 2016
1007 posts
Posted on 6/1/18 at 8:11 am to
Congrats on getting someone to do your work for you. Now get back to work!
Posted by GetCocky11
Calgary, AB
Member since Oct 2012
53509 posts
Posted on 6/1/18 at 8:11 am to
SecondGeneratedNumber = FirstGeneratedNumber + 1
This post was edited on 6/1/18 at 8:12 am
Posted by Kingpenm3
Xanadu
Member since Aug 2011
9977 posts
Posted on 6/1/18 at 8:12 am to
d4=d3+3 e4=d3+3 ctrl c, ctrl v
Posted by castorinho
13623 posts
Member since Nov 2010
88341 posts
Posted on 6/1/18 at 8:13 am to
If your variable is Cell A and the other two are B and C then
Cell B is 52+(cellA-2)*3, cell C is Cell B+1

This seems pretty straightforward unless I missing something

Posted by Centinel
Idaho
Member since Sep 2016
46695 posts
Posted on 6/1/18 at 8:14 am to
Tree-fiddy or so.

Posted by CoachChappy
Member since May 2013
34329 posts
Posted on 6/1/18 at 8:15 am to
Taking ISDS in the summer session?
Posted by NATidefan
Two hours North of Birmingham
Member since Dec 2008
36788 posts
Posted on 6/1/18 at 8:15 am to
quote:

SecondGeneratedNumber = FirstGeneratedNumber + 1


That is the relation between formula 1 and formula 2.

But that part is easy.
Posted by The Torch
DFW The Dub
Member since Aug 2014
30483 posts
Posted on 6/1/18 at 8:15 am to
My as well be in French
Posted by IT_Dawg
Georgia
Member since Oct 2012
26817 posts
Posted on 6/1/18 at 8:16 am to
Done. Now what?
Posted by rumproast
Member since Dec 2003
12473 posts
Posted on 6/1/18 at 8:16 am to
I'm coming up with 32.33, repeating of course, percentage of survival.
Posted by tidalmouse
Whatsamotta U.
Member since Jan 2009
30706 posts
Posted on 6/1/18 at 8:18 am to
quote:

69


69=241
Posted by randybobandy
NOLA
Member since Mar 2015
2200 posts
Posted on 6/1/18 at 8:18 am to
One day you will touch a boobie and forget all about this math stuff.
Posted by NATidefan
Two hours North of Birmingham
Member since Dec 2008
36788 posts
Posted on 6/1/18 at 8:21 am to
quote:

If your variable is Cell A and the other two are B and C then
Cell B is 52+(cellA-2)*3, cell C is Cell B+1


Different from mine... But looks like it works


Mine was 46+3*(cellA). And 47+3*(cellA)

ETA: Yep... Same as mine once it's condensed down... nice job.
This post was edited on 6/1/18 at 8:26 am
first pageprev pagePage 1 of 2Next pagelast page

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on X, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookXInstagram