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.

This post was edited on 12/27/14 at 1:02 am

3 ...

Report Post

Posted by OBReb6

Memphissippi

Member since Jul 2010

37944 posts

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.

0 ...

Report Post

Posted by genro

Member since Nov 2011

61788 posts

Posted on 12/27/14 at 1:07 am to KSGamecock

KSG doin' some educatin'

Thank God/no one that genro saved this board

1 ...

Report Post

Posted by WhiskerBiscuitSlayer

Member since Jan 2013

13842 posts

Posted on 12/27/14 at 7:00 pm to KSGamecock

quote:
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.

No you don't. I got certified by Microsoft at one of their courses. Most boring 3 weeks of my life. I wouldn't wish that boredom on my worst enemy. Useful skill but still, damn.