- 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
Any Excel experts want to take a shot at this?
Posted on 6/28/18 at 3:56 pm
Posted on 6/28/18 at 3:56 pm
I need a formula for the following:
I need a cell in column R to multiple by 1.06 a cell in column Q. Then, I need the same cell in column R to run these calculations:
"Whole number. Must meet divisibility requirements < 20000 / 100; >= 20000 < 38000 /200; >=38000 / 500
Minimum 6000
"
Anyone want to take a shot at the formula?
I need a cell in column R to multiple by 1.06 a cell in column Q. Then, I need the same cell in column R to run these calculations:
"Whole number. Must meet divisibility requirements < 20000 / 100; >= 20000 < 38000 /200; >=38000 / 500
Minimum 6000
"
Anyone want to take a shot at the formula?
19
Posted on 6/28/18 at 3:57 pm to MardiGrasCajun
TREE FIDDY Pivot table
Move to the Poli Board
Move to the Poli Board
This post was edited on 6/28/18 at 3:58 pm
Posted on 6/28/18 at 3:57 pm to MardiGrasCajun
Posted on 6/28/18 at 3:57 pm to MardiGrasCajun
That’s easy. =sum(treefiddy)
Posted on 6/28/18 at 3:57 pm to MardiGrasCajun
Easy, what cell number in Column R and Cell number in Column Q
Posted on 6/28/18 at 3:58 pm to MardiGrasCajun
The answer is 7 or Watergate
Posted on 6/28/18 at 3:58 pm to MardiGrasCajun
what are you, my final?
This post was edited on 6/28/18 at 3:59 pm
Posted on 6/28/18 at 3:58 pm to MardiGrasCajun
Just input 3/5ths law
Posted on 6/28/18 at 3:58 pm to MardiGrasCajun
C6*H9[6000] = tree fiddy
Posted on 6/28/18 at 3:58 pm to TennesseeFan25
quote:
Easy, what cell number in Column R and Cell number in Column Q
Cell 4 for this example. However, I have 1000's to do.
Posted on 6/28/18 at 3:59 pm to MardiGrasCajun
Pancakes.
Posted on 6/28/18 at 3:59 pm to MardiGrasCajun
quote:
Cell 4 for this example. However, I have 1000's to do.
Roger, the way you laid out the initial post it seemed like it was only for a single cell.
I'll work it out real quick
Posted on 6/28/18 at 4:00 pm to MardiGrasCajun
IN as ninth useless reply.
Posted on 6/28/18 at 4:01 pm to MardiGrasCajun
I have a macro that does this
Posted on 6/28/18 at 4:01 pm to JPinLondon
quote:
IN as ninth useless reply.
Thanks. I expected these replies.
Posted on 6/28/18 at 4:02 pm to MardiGrasCajun
This post was edited on 6/28/18 at 4:09 pm
Posted on 6/28/18 at 4:02 pm to MardiGrasCajun
This sounds like a very easy problem to solve but you're so awful at asking the question I don't want to deal with it 
Posted on 6/28/18 at 4:02 pm to MardiGrasCajun
I'm going to send you the excel template, easier than having to copy to the range with potential for mix ups, what's your email address?
Posted on 6/28/18 at 4:03 pm to TennesseeFan25
ETA: to remove email address.
This post was edited on 6/28/18 at 4:08 pm
Page 1 of 2
Popular
Back to top
Follow TigerDroppings for LSU Football News