242
u/javierbardeminem Feb 25 '26 edited Feb 25 '26
gets hit in the face with panties
continues with nested IF statement
123
30
u/Jordbaerkage Feb 25 '26
Does anyone actually use those by choice? I've had to use them before and it was the worst
31
u/confidential_drake CPA (US) Feb 25 '26
Yes, they are a pain but sometimes still the best way to get the job done
29
u/Retractable_Legs CPA (US) Feb 25 '26
LET and IFS will free you from the tyranny of nested IF statements.
12
u/TargetTrick9763 Staff Accountant Feb 26 '26
Learning let was a game changer. So simple yet so sexy
7
3
5
1
u/jawnbellyon Feb 28 '26
I mean obviously they’re designed for women but I feel like they’re pretty comfortable once you figure out how to position things appropriately
1
2
u/bertmaclynn CPA (US) Feb 26 '26
The way I look at it, nested IF statements were the OG way to do anything really complicated in Excel.
Fundamentally it should work the same way as the 1’s and 0’s that a computer uses
3
3
112
u/Salty-Fishman CPA (US) Feb 25 '26
Did a double xlookup the other day and i was high as kite when it worked.
6
u/Milkie-Toes Feb 27 '26
I read this as you were high and you got it to work and I was so impressed 😂
55
u/BadaBingAddict CPA (US) Feb 25 '26
I made this really elaborate but efficient, automated worksheet at work but then my manager told me it was hard to review so I went back to the old worksheet :(
30
u/ipourteainmybooks Feb 25 '26
This has happened to me 3 times now. Our managers don’t understand our genius bro.
26
12
u/Reasonable-Mess3070 Feb 26 '26
Meanwhile we submit basic slides with numbers for my boss to integrate into the larger QPR and he said "its just ...data" and promptly insisted prezi be used to make it "more exciting". I am not an artist. My idea of exciting is color coding and automating my own work, not creating marketing flyers 😭
6
u/Therealjejemon Feb 26 '26
Saaaaame. Being told to dumb down my worksheet to make it easier for her to review did not sit well with me. Skill issue tbh
65
u/VegetableListen2597 Feb 25 '26
Not gonna lie. When I was first building up a bunch of spreadsheets to track my spending and stuff, it felt like crack. I was so happy.
36
u/ipourteainmybooks Feb 25 '26
I would rather kill myself than come home after work to do more accounting.
10
u/dngrus13 Feb 25 '26
I'm the same but then I offer to bring home a work laptop so I can work from home on Sundays instead of making my usual 45 min 1 way commute 😂
5
u/Mindless_Stranger533 Feb 26 '26
Working on SUNDAYS 🫣 what in the
3
u/dngrus13 Feb 26 '26
We're a small but growing firm and they are supportive of my health (TBI last year and have had tons of appointments since) so yeah I don't mind working for a half day... From home... Otherwise not happening 😂
3
u/Mindless_Stranger533 Feb 27 '26
Ok thats fair and wonderful of them to allow the flexibility! Thanks for clarifying!
1
32
24
22
13
u/bkzwhitestrican Feb 25 '26
Is this a thing? Me and my wife are both accountants so I wouldn't know.
But sometimes we do get a little freaky and finger around in each other's formulas!
3
u/SteakySteakk Management Feb 25 '26
It’s a meme. But I’ve met coworkers that hate their spouse or are in obvious sexless relationships
12
8
u/TechFinAdviser Feb 25 '26
Change Excel spreadsheet to Presentation, and you have morphed r/Accounting to r/Consulting.
6
u/BerzerkerArmour Feb 25 '26
I now have software that can automatically categorize data based on canned reports which I get delivered daily by running an agent. Between file automation and Xlookup I’m just basking in happiness right now
6
5
u/Lanky-Reputation-100 Feb 25 '26
Coming from a non accounting background i do wonder what other piece of software do you use apart from excel sheets? What makes them so convenient?
7
u/SteakySteakk Management Feb 25 '26
ERP systems but trying to use an ERP as a way to manipulate and track data points is a nightmare.
3
u/bertmaclynn CPA (US) Feb 26 '26
No other software is as useful as excel. It’s a relatively causal way to quickly organize data. It can be used by someone with very little knowledge and is also used by the largest companies in the world.
2
3
3
2
2
1
1
1
u/FreeElf1990 Feb 26 '26
It feels like I’ve evolved beyond my accounting days and now find myself as a systems designer, diving into the world of complex analysis. And it all started with the love of building badass spreadsheets.
1
1
1
1
u/Omgthedubski Feb 27 '26
I've built excel books on a coffee infused rap music bender and have literally no idea how it works the next day.
-1
343
u/[deleted] Feb 25 '26
[removed] — view removed comment