- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message

OT math puzzle solvers...
Posted on 6/1/18 at 8:06 am
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
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 on 6/1/18 at 8:08 am to NATidefan
Honestly, it's Friday and at 8am
I don't give a flying frick about math, about work, about anything
I don't give a flying frick about math, about work, about anything
Posted on 6/1/18 at 8:09 am to NATidefan
I don’t understand the question.
Posted on 6/1/18 at 8:11 am to NATidefan
Congrats on getting someone to do your work for you. Now get back to work! 
Posted on 6/1/18 at 8:11 am to NATidefan
SecondGeneratedNumber = FirstGeneratedNumber + 1 
This post was edited on 6/1/18 at 8:12 am
Posted on 6/1/18 at 8:12 am to NATidefan
d4=d3+3 e4=d3+3 ctrl c, ctrl v
Posted on 6/1/18 at 8:13 am to NATidefan
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
Cell B is 52+(cellA-2)*3, cell C is Cell B+1
This seems pretty straightforward unless I missing something
Posted on 6/1/18 at 8:15 am to NATidefan
Taking ISDS in the summer session?
Posted on 6/1/18 at 8:15 am to GetCocky11
quote:
SecondGeneratedNumber = FirstGeneratedNumber + 1
That is the relation between formula 1 and formula 2.
But that part is easy.
Posted on 6/1/18 at 8:16 am to NATidefan
I'm coming up with 32.33, repeating of course, percentage of survival.
Posted on 6/1/18 at 8:18 am to NATidefan
One day you will touch a boobie and forget all about this math stuff.
Posted on 6/1/18 at 8:21 am to castorinho
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
Popular
Back to top

17














