Started By
Message
re: Who Holds the Record For Most Posts on this Site?
Posted on 12/27/14 at 12:46 am to OBReb6
Posted on 12/27/14 at 12:46 am to OBReb6
=IF(test/condition, value if true, value if false)
So say you have a column A with a bunch of values, posts if you will. You want to say that posters with more than 10,000 posts have no life, those under have a life.
B1 would be =IF(A1>10000, "Has no life", "Has a life")
So say you have a column A with a bunch of values, posts if you will. You want to say that posters with more than 10,000 posts have no life, those under have a life.
B1 would be =IF(A1>10000, "Has no life", "Has a life")
This post was edited on 12/27/14 at 12:50 am
Posted on 12/27/14 at 12:48 am to KSGamecock
Interesting. Whenever I dig through estimate sheets at work that is always the function that I couldn't figure out
Posted on 12/27/14 at 12:49 am to StrawsDrawnAtRandom
i have the most...look how many posts i have!!!!!!!
Posted on 12/27/14 at 12:54 am to KSGamecock
Our sheets show an IF function to produce a uniform material cost per pound of differing material types. Always stumped me, but that's why I'm not in estimating.
Posted on 12/27/14 at 12:55 am to KSGamecock
quote:
Posters who have posted in this thread are highlighted in red just for context to see where we stack up.
That's really fricking cool. I guess I need to step my game up
Posted on 12/27/14 at 12:57 am to OBReb6
I posted a really simple IF example, you can stack and add shite to make them more complicated. I've had formulas that were +100 characters and were needlessly complicated, the excel equivalent of jerry rigging shite and when it came time to explain it to my replacement I had completely lost myself.
My top three days in excel:
1. When I learned how to write/record macros
2. When I learned how to create pivot tables
3. When I learned how to use formulas
I went from barely being able to keep up with my work to getting my stuff done in under an hour or two each day. Excel is the shite if you can make it work for you. There are classes and stuff...wish I had gone to them. Google taught me everything but it took a long arse time because am idiot.
My top three days in excel:
1. When I learned how to write/record macros
2. When I learned how to create pivot tables
3. When I learned how to use formulas
I went from barely being able to keep up with my work to getting my stuff done in under an hour or two each day. Excel is the shite if you can make it work for you. There are classes and stuff...wish I had gone to them. Google taught me everything but it took a long arse time because am idiot.
This post was edited on 12/27/14 at 1:02 am
Posted on 12/27/14 at 12:59 am to KSGamecock
Yeah the ones I'm talking about are showing 20+ different price per pound materials and the equation is long and drawn out. Your simple explanation actually helped me grasp it though.
Posted on 12/27/14 at 1:07 am to KSGamecock
KSG doin' some educatin'
Thank God/no one that genro saved this board
Thank God/no one that genro saved this board
Posted on 12/27/14 at 1:09 am to genro
Thank you genro. I bitched at you but truth be told, you knew what was best for us...as usual.
Posted on 12/27/14 at 1:18 am to KSGamecock
No problem.
And again I apologize for being more mellow, happier, nicer, and more at peace than I used to be.
That's my bad.
And again I apologize for being more mellow, happier, nicer, and more at peace than I used to be.
That's my bad.
Posted on 12/27/14 at 1:34 am to KSGamecock
Nananananananananana.........CHARTMAN!!!
Posted on 12/27/14 at 7:44 am to KSGamecock
Why don't you have me highlighted, bro?
Posted on 12/27/14 at 7:49 am to BigOrangeBri
Also, LSUROCKS has a lot more posts than appears by his username. Chicken reset his and it hardly goes up anymore, IIRC. He probably has second most behind SlowFlowPro.
Posted on 12/27/14 at 8:06 am to KSGamecock
quote:
KSGamecock
Have you ever tried using MS Access?
Posted on 12/27/14 at 8:14 am to KSGamecock
my post per day has dropped the last few months. I blame the demise of the IM thread
its not hard to rack up 50 post per day when you spread it out between different boards.
its not hard to rack up 50 post per day when you spread it out between different boards.
Posted on 12/27/14 at 8:24 am to heartbreakTiger
How many of Powerman's posts are him telling someone that they are the worst poster on this board?
This post was edited on 12/27/14 at 8:25 am
Posted on 12/27/14 at 8:25 am to Vols&Shaft83
Im guess about half of them.
Posted on 12/27/14 at 9:54 am to plazadweller
quote:
Have you ever tried using MS Access?
A little bit. I'm trying to learn it.
Popular
Back to top
Follow SECRant for SEC Football News