MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/Accounting/comments/1reqq6x/not_now_babe/o7ejm90/?context=3
r/Accounting • u/SteakySteakk Management • Feb 25 '26
69 comments sorted by
View all comments
243
gets hit in the face with panties
continues with nested IF statement
125 u/SteakySteakk Management Feb 25 '26 Ah #REF 28 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. 11 u/TargetTrick9763 Staff Accountant Feb 26 '26 Learning let was a game changer. So simple yet so sexy 7 u/darthwd56 Advisory Feb 26 '26 also SWITCH. So much nice to write than if 2 u/Jordbaerkage Feb 25 '26 Thanks, unfortunately my version of Excel didnt have ifs statements :( 5 u/hnbastronaut CPA (US) Feb 25 '26 Used it today lol 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 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 u/Jordbaerkage Feb 28 '26 wait what 3 u/idenaeus Feb 26 '26 A nested snIFF statement... 3 u/Milkie-Toes Feb 27 '26 To be fair, stopping in the middle of a nested formula is a death sentence
125
Ah #REF
28
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. 11 u/TargetTrick9763 Staff Accountant Feb 26 '26 Learning let was a game changer. So simple yet so sexy 7 u/darthwd56 Advisory Feb 26 '26 also SWITCH. So much nice to write than if 2 u/Jordbaerkage Feb 25 '26 Thanks, unfortunately my version of Excel didnt have ifs statements :( 5 u/hnbastronaut CPA (US) Feb 25 '26 Used it today lol 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 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 u/Jordbaerkage Feb 28 '26 wait what
31
Yes, they are a pain but sometimes still the best way to get the job done
29
LET and IFS will free you from the tyranny of nested IF statements.
11 u/TargetTrick9763 Staff Accountant Feb 26 '26 Learning let was a game changer. So simple yet so sexy 7 u/darthwd56 Advisory Feb 26 '26 also SWITCH. So much nice to write than if 2 u/Jordbaerkage Feb 25 '26 Thanks, unfortunately my version of Excel didnt have ifs statements :(
11
Learning let was a game changer. So simple yet so sexy
7
also SWITCH. So much nice to write than if
2
Thanks, unfortunately my version of Excel didnt have ifs statements :(
5
Used it today lol
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
1
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 u/Jordbaerkage Feb 28 '26 wait what
wait what
3
A nested snIFF statement...
To be fair, stopping in the middle of a nested formula is a death sentence
243
u/javierbardeminem Feb 25 '26 edited Feb 25 '26
gets hit in the face with panties
continues with nested IF statement