Related Posts
Hi Everyone! I have been working in Salesforce for about a year now. But I am not enjoying my work as it's mainly on backend. I have been wanting to move to Web Dev. But someone suggested that like if I like frontend I should try LWC instead as I'm already into Salesforce. So I'm quite confused which way should I go. Can anyone help me with the same Tata ConsultancyAccentureDeloitteZS AssociatesInfosysSalesforceSalesforceAmazonMicrosoft
Hi folks, how is thoughtworks as an organisation?
Asking because I don't know much about it and have received recruiter's call today. Currently I am working in Deloitte. How is thoughtworks hikes, wlb, does it provide any benefits apart from fixed pay? My research gives me a mixed review: some say it's good, some say that thoughtworks is not stable enough like big 4 or other organisations. Pls help Thoughtworks Deloitte
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
unlock all discussions on Fishbowl.






And definitely let me know if you have any questions or feedback.
I’m focused on making content that is entertaining and instructs effectively. This is video 3 of 50, I’m not great yet, but getting much better and quickly.
This is great
I love your content! Super clear and funny! Great production too! Thank you!
Thanks for watching and the kind words! I’ll keep these coming out every week or two. Goal is to get to one a week.
This is great!
Heck yeah, thanks for watching!
Impressive! Thanks for sharing!
Thanks for watching!
I love it - I didn’t know this function existed and it’s way better then creating my nested if statements. Can’t wait to try it.
And you’re in good company! I remember being surprised that the function had already existed for a while when I first learned about it. Do you use Excel a lot?
Thanks for watching!
How is the performance on this compared to a series of if’s in a large data set 100k+? I have broken my if’s into a series of 7 different cells to try and get it to fail the data set as quickly as possible or arrive at the most common scenario as quickly as possible. I’m wondering how using IFS would impact the performance. We’re still stuck using 32bit office, so I do not have a large amount of memory to play with in the application. If it improves speed/responsiveness it might be worth me switching some of the formulas.
I don’t know with any certainty, but I have to assume that IFS is a more optimized function given its whole reason to exist was to fix nested if functions.
With that said, here’s a reddit thread where users suggest it’s not any faster, so in that case just a syntax improvement. https://www.reddit.com/r/excel/s/az7eurwR7U
Depending on the logic required for your situation, an xlookup could be much more performant.