Started By
Message

re: Any Excel experts want to take a shot at this?

Posted on 6/28/18 at 4:03 pm to
Posted by MardiGrasCajun
Dirty Coast, MS
Member since Sep 2005
6016 posts
Posted on 6/28/18 at 4:03 pm to
quote:

but you're so awful at asking the question I don't want to deal with it
Posted by tss22h8
30.4 N 90.9 W
Member since Jan 2007
18793 posts
Posted on 6/28/18 at 4:04 pm to
Posted by scottfruget
Member since Nov 2010
3392 posts
Posted on 6/28/18 at 4:06 pm to
quote:

redknight6977@yahoo.com


Porn incoming
Posted by MardiGrasCajun
Dirty Coast, MS
Member since Sep 2005
6016 posts
Posted on 6/28/18 at 4:07 pm to
quote:

Porn incoming


This was the plan from the beginning.
Posted by AA77
Member since Jan 2016
3853 posts
Posted on 6/28/18 at 4:08 pm to




Posted by MardiGrasCajun
Dirty Coast, MS
Member since Sep 2005
6016 posts
Posted on 6/28/18 at 4:16 pm to
quote:

what's your email address?


Did you send it? I've only received an email from some Nigerian guy.
Posted by TennesseeFan25
Honolulu
Member since May 2016
8391 posts
Posted on 6/28/18 at 4:26 pm to
quote:

Did you send it? I've only received an email from some Nigerian guy.


No, got called away for a moment and didn't actually catch it
Posted by readysetgeaux
Member since Jun 2012
208 posts
Posted on 6/28/18 at 4:27 pm to
=IF((Q2*1.06)>=38000,(Q2*1.06)/500,IF((Q2*1.06)<20000,(Q2*1.06)/100,(Q2*1.06)/200))
Posted by Kcrad
Diamondhead
Member since Nov 2010
66923 posts
Posted on 6/28/18 at 4:31 pm to
Posted by MardiGrasCajun
Dirty Coast, MS
Member since Sep 2005
6016 posts
Posted on 6/28/18 at 4:37 pm to
Thanks everyone!

Posted by Winston Cup
Dallas Cowboys Fan
Member since May 2016
66904 posts
Posted on 6/28/18 at 4:46 pm to
the levels of ifs are giving me a headache, but you need if(mod)

=IF(F1<20000,(IF((MOD(F1,100)=0),F1*1.06,0)),"false")

something like that i think
Posted by tokenBoiler
Lafayette, Indiana
Member since Aug 2012
5046 posts
Posted on 6/28/18 at 5:02 pm to
quote:

I have a macro that does this
I've seen better macros on the quad.
Posted by tokenBoiler
Lafayette, Indiana
Member since Aug 2012
5046 posts
Posted on 6/28/18 at 5:03 pm to
quote:

Thanks. I expected these replies.


You've come to the right place, then.
Posted by Winston Cup
Dallas Cowboys Fan
Member since May 2016
66904 posts
Posted on 6/28/18 at 5:10 pm to
=IF(Q1<20000,(IF((MOD(Q1,100)=0),Q1*1.06,0)),(IF(AND((Q1)>=20000,(Q1)<38000),IF((MOD(Q1,200)=0),Q1*1.06,0),(IF((Q1>=38000),IF((MOD(Q1,500)=0),Q1*1.06,0))))))


you should be able to copy it down the page

your welcome. that will be $150



this will exclude items in Q1 less than 6000

=IF(Q1<6000,0,(IF(Q1<20000,(IF((MOD(Q1,100)=0),Q1*1.06,0)),(IF(AND((Q1)>=20000,(Q1)<=38000),IF((MOD(Q1,200)=0),Q1*1.06,0),(IF((Q1>=38000),IF((MOD(Q1,500)=0),Q1*1.06,0))))))))
This post was edited on 6/28/18 at 5:54 pm
Posted by lake chuck fan
Vinton
Member since Aug 2011
23663 posts
Posted on 6/28/18 at 5:11 pm to
Lazy arse.... Google it and figure it out! Like the rest of us!
Posted by Winston Cup
Dallas Cowboys Fan
Member since May 2016
66904 posts
Posted on 6/28/18 at 5:16 pm to
seriously. i come here to bash louisiana, determine whether i would but most of the time wouldnt hit it, or see reposted barstool content.

if i wanted to work i wouldnt log on in the first place.
Posted by starsandstripes
Georgia
Member since Nov 2017
11897 posts
Posted on 6/28/18 at 6:55 pm to
Stopping dicking around with Excel and use a real program like SAS. Very easy to do this in SAS with a couple lines of code. Takes less time than figuring out clumsy Excel formulas. Can also use MATLAB and you can purchase your own license for that pretty cheap.
Posted by CptBengal
BR Baby
Member since Dec 2007
71661 posts
Posted on 6/28/18 at 6:58 pm to
quote:

Stopping dicking around with Excel and use a real program like SAS.


Good god.

You try and dick slap him with a large clitoris.
Posted by gaetti15
AK
Member since Apr 2013
15287 posts
Posted on 6/28/18 at 7:00 pm to
R is free and can do this as well
first pageprev pagePage 2 of 2Next pagelast page
refresh

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