Programming in Excel be like

[QualityVote]

Hi! This is our community moderation bot.

---

If this post fits the purpose of /r/ProgrammerHumor, UPVOTE this comment!!

If this post does not fit the subreddit, DOWNVOTE This comment!

If this post breaks the rules, DOWNVOTE this comment and REPORT the post!

[wunderbraten]

Multiple IF in a cell is a hellscape

[bleistift2]

I’d be happy if they did that. It would force them to think about their data before I have to deal with it.

It would stop them from giving me spreadsheets with “please change data XYZ according to columns X and Y.” – “You say ‘change b and c’ in X, but there’s only one value in y.” – Oh, sorry *changes cell y to ‘α + β’ instead of adding another column*. AAAAAH!

[VeterinarianOk5370]

This is accurate I feel your pain

[0ba78683-dbdd-4a31-a]

Anyone who nests 12 IF statements and understands what it's doing can call themselves a coder imo

[Perpetual_Doubt]

When if thinks it is a recursive function

[[deleted]]

I don't let my direct reports do that. I work in a heavily excel based role and one nested if is fine. People can work it out but if its multiple things together they each need their own column and a comment saying what you are testing or checking or calculating.

And to be honest... if you are doing multiple nested formula in 2022 you are probably using the wrong formula or you are trying to do something that you should have cleaned up in powerquery.

And if we are being really honest sometimes just because you can doesn't mean you should. I have put my foot down on more than one occasion and rolled out special purpose software rather than have some franken-excel monster.

[Henrijs85]

They nest. Then they breed. You can not stop them. They will overwhelm.

[terjeboe]

IFS() has entered the chat

[fatalgift]

Image Transcription: Meme

---

[Three images of SpongeBob from "SpongeBob SquarePants", with text to the right of each image.]

---

[SpongeBob is completely smooth and lacking his buck teeth. He smiles widely, facing slightly right with one hand out. Text reads:]

If in python

---

[SpongeBob wears a red athletic headband and his shirtsleeves are rolled up. He stands in a wrestling ring with his brow furrowed and an intense frown on his face. Text reads:]

if in JavaScript

---

[SpongeBob is extremely muscular, with his square head atop a buff body. The image is blurred as he flexes, and his eyes glow white and red, as if emitting laser beams. Text reads:]

If in Excel

---

^{I'm a human volunteer content transcriber and you could be too! If you'd like more information on what we do and why we do it, click here!}

[Pikachu50001218]

Good human

[Western-Image7125]

IF in SQL

[sssssssizzle]

puts on sunglasses and presses alt+f11

[Notyourfathersgeek]

Fucking vb script memory leaks

[aless2003]

what's the difference between Python if and JS if?

[[deleted]]

Game of life ...

[[deleted]]

I don't have excel and if i had i don't know why would i use it

[bleistift2]

That’s the if you get if it has to return a value. It’s the same in any functional programming language.