#nested IF Excel

[radiantresume]

Top 20 IF Formulas in Excel – A Complete Guide

Excel’s IF function is the backbone of decision-making formulas, allowing users to automate calculations and streamline data analysis. Whether you’re a beginner or advanced Excel user, knowing how to use the IF function in various combinations is essential. In this guide, we’ll explore the Top 20 IF Formulas that can significantly improve your Excel workflow. From basic comparisons to complex…

[bigcats-birds-and-books]

y'know it wasn't until i went to pull all my stats data off the nano website that i realized: it's not actually gr8 for grabbing things in one fell swoop, huh??

[softness-and-shattering]

Rotating Mizu in my mind, this man is so entirely transgender.

Rotating him with Taigen they are extremely homoerotic. Rotating Akemi she's very surprising. And Ringo so upbeat and sweet despite it all.

Rotating Rotating mm some fucking delicious food.

[batsplat]

Thank you for typing all that out!!!! I was like they had beef??? But it makes sense. I was listening to Casey on the gypsy tale podcast, he mentioned how he was envious of Marc/Vale who had no fear of the track. Makes sense that Marc - the limit of the bike is when I crash - and him would clash even if it wasn't malicious or personal.

(about this) haha no problem! and yeah for sure I don't think it's anything particularly malicious and it's not even BEEF as much as a low-level grudge, the kind of thing that naturally bubbles up when you have athletes' egos existing within a team structure. though I do think the stuff you mention (ie marc's approach to the sport) is something that never did become much of an issue between the two of them, but only because... well they weren't on-track rivals

ofc that's one of motogp's biggest 'what ifs' - what if we'd actually seen casey and marc compete - so none of this is particularly original, but, look, it's a fun one to discuss! casey's for the most part been pretty schtum about marc's actual races and various controversies, but has on occasion mentioned not necessarily being the biggest fan of marc's approach, eg (from 2013):

the "humiliate them" bit is most interesting to me - does feel a similar vibe to some of his complaints about valentino's propensity for mind games. the implications of marc wanting to humiliate opponents would be that for marc, it's not just about just wanting to win, it's about what effect he's having on rivals, about wanting to mess with them

so I - like everyone else - can only IMAGINE what it would've been like if casey had actually had to live the full marc marquez experience. it's a respectful relationship irl because it's a rivalry that never actually got to play out, so casey doesn't have any real motivation to criticise marc much beyond low stakes honda hijinks. and marc probably would have enjoyed getting the chance to race casey, but from casey's side? eh

obviously casey's issues with valentino's riding standards are pretty well-documented (as well as his issues with other rivals, including a younger jorge) (and various somewhat less significant figures, like him and his buddy in 125cc giving alex de angelis the truly terrible nickname of 'alex dangerous'. casey please). marc is relentlessly aggressive in a way casey would not have enjoyed at all, and would've also objected to on grounds of principle. the fearlessness thing you mention from that very very long podcast episode is interesting to me, because yes casey would have liked to emulate that in some ways... but he does also have his issues with riders who ride without fear to the extent that they don't care about their own safety. from his autobiography, explaining his increasing disillusionment with MotoGP:

The most fitting tribute to [Simoncelli's] memory shouldn't have been a plaque by the side of the track where he lost his life, but a real change in the way riders respect each other and respect the limits. Unfortunately, I don't feel that this happened. I have always been very aware of what can happen in this sport, which is why I have always shown respect to my fellow racers. You might not like the person next to you on the grid but you have to be aware that if an accident happens, anyone can be hurt or killed. Sometimes young riders are so desperate to win that they forget what's most important. They get built up so much that they start to believe the hype, they feel invincible. Nobody is, especially in bike racing. And if a rider doesn't care about his own safety then it stands to reason he doesn't care about anybody else's either. Don't get me wrong, MotoGP is as safe as it has ever been in terms of the gravel traps, circuit layouts and rider equipments, but the fact that certain riders were still putting others at risk even after Marco's death bothered me a lot.

which, yup, can't see casey being a fan of marc. he's got some very ironclad beliefs when it comes to riding standards and the importance of rivals respecting each other and what that looks like on track in terms of hard racing - it's just an outlook and approach that would always have clashed with marc's. (also, yeah, like casey admits, it does just scare him! laguna seca 2008 wasn't fun for him because he was worried about his safety! which is entirely understandable, but I can't imagine if that's the case he'd feel particularly comfortable or indeed safe racing marc marquez.) on marc's side, even in 2013 he was pretty good at shrugging off these kind of critiques from his rivals, including ofc from dani and especially jorge that year. so maybe it'd be mostly one-way antipathy, but probably not all that pleasant for anyone involved. livio suppo said back in 2020 that casey would've suffered a lot from marc's personality, and also in 2023 said this:

I don't really agree with suppo about 2008 and it does lean into the frustrating trope (which casey also chafed against in his autobiography) that seeks to explain all of casey's struggles and defeats by what was going on in his head. like, I do think he would've done a good job fighting marc! he would've won plenty of their duels, even when they were fighting wheel-to-wheel! he did say repeatedly after laguna seca 2008 that if something like that happened again, he wouldn't roll over for valentino (unfortunately we never really had the chance to properly test this but oh well)! he just wouldn't have enjoyed it, which is kinda why he retired in the first place

basically, they respect each other just fine because they never had the chance to fight on track. if they HAD fought on track, things would've inevitably been more fraught, not least because of their very different approaches to racing, as well as how by marc's own admission he's an asshole as a teammate. that difference in approaches is where the 'fearlessness' of marc comes in, and not in a good way for that relationship. who knows how it would have all turned out

just one more thing - marc is actually asked about the "he wants to humiliate them" quote in a presser, but unfortunately the question is formulated in a kinda messy way so marc doesn't really end up directly addressing the comments. though my guess is at least one person present understood exactly what casey was getting at:

[agnesandhilda]

blue lock wouldn't exist if ego jinpachi weren't a misogynist. and I stand by that

[mortal-queer]

I genuinely can't spend very long in the Hozier tag because I'll see at least 3 (non-irish) people talking about his political songs/references without mention the very fucking clear tie to Ireland and either it's history or current politics OR WORSE making the song horny?????? Someone said this about Empire Now?????? I am turning my PHONE OFF

It's like they'll acknowledge he's Irish when he's singing about love and nature and "sexy bogman!!!" But as soon as it's a political point the context of his irishness gets completely fucking removed. As though him being Irish doesn't have some shape on his politics! Fuck offffff.

[pathologicalrunaway]

Fandom: Sky: Children of the Light (Video Game) Characters: The Prince | Alef, King Resh | Eden Elder, Nesting Guide (Sky: Children of the Light) Additional Tags: Random Encounters, Character Study, Light Angst, Conversations Summary:

“I’m fine. Practicing,” they nod towards the spinning objects, “the Elder says I have to learn to multitask. Don’t see how doing tricks with rocks will help me, but it’s fun, I guess.”

Alef smiles. Have have not changed that much, after all.

“You are demonstrating some good magic skills.”

“Thank you, your Highness.”

___

They only meet a couple of times, and these encounters have no particular importance for either of them. But they do form a pattern, once put side by side.

[anomalousmancunt]

I made one post about how being mean shouldn't be more important than actually building community and I stand by it.

There is a difference between being allowed to be angry (that is a Feeling and you're allowed to Feel things always) and being cruel/mean to other people (counterproductive and also not a good thing to do). But more importantly: if your priority is to Be Mean at the Enemy, you will end up with people you're supposed to be building a community with caught in the crossfire - and it's not unlikely you will not notice.

[tendercherie]

Could w-

Cou-

Could we take turns playing with each others' hair and falling asleep in each others' arms?

Of course!!! I give excellent head scratches :)

[shamelesslymkp]

just for the record and as a warning to other fen, never get super into two+ fandoms featuring the same sort of supernatural beings or you're going to run into all sorts of bookmark tagging shit where it's like 'are these ghost rules danny phantom ghost rules or dead boy detectives ghost rules' and your entire setup for bulk renaming pinboard bookmark tags via python script gets fucked

um. as a completely hypothetical and not incredibly specific example.

[ru5t]

@loetise //> That Was Way Too Close

“I like your hiding spot.” -- i don't know where to put her in the tech sandbox yet but this could be funny just for like. modern or desc. she's just talkin like :D even tho the meme context is supposed to be scarey

  Maddy never planned this far ahead. She'd mostly just wanted to get this girl out of that club. Get them both out of that club. Because she was a little more together, but not a lot. And definitely still, also kind of drunk. Drunk, though, was much better condition than the way this girl did not seem to know where she was, or where her friends were -or if she even had any who were out with her? Maddy honestly was unclear on the whole situation other than that they'd both started getting harassed by the same pack of creeps. All she'd been able to think to do about it was this.

  And now, a short train ride away, she had a strange girl in her apartment and... no idea what to do next. She laughed a little, self-conscious. “Uh, thanks. It's like..” Scattered with books she hadn't bothered to put away, and clothes draped over various surfaces. Shoes in the middle of the living room and little bits of hardware laying out just... everywhere. After closing the door behind them, Maddy hastily cleared approximately 45-thousand mugs off the sparse kitchen counter into the sink, wincing at the noise. “A mess. Sorry.”

  There was a fairly cozy little apartment somewhere underneath it all, with plenty of brightly colored cushions and fuzzy blankets, but she imagine it was hard to see under the clutter and cat toys.

  “Can I- do you, like. .. Are you hungry? I'm hungry.”

[little-mouse-adventures]

Not me spending an hour and a half teaching myself new Excel and Word tricks to automate a 5min task

[llycaons]

ik jyl is underdeveloped and stereotypical but there are ways to develop and respect her character that aren't having her do things she simply wouldn't do

[choppedcowboydinosaur]

New Yorkers brag about their bodegas but do they have Chinese corner stores with balut and unique random Asian foods? I think not.

[shorlinesorrows]

kind of ashamed there isn't more lock-in aus in fanfic

i feel like we should be doing better as a collective

[palindrome-mystery]

Coach Rhemann trying his best to support Jean but also trying to figure out if some oddities are result of:

abuse from his time in the nest

a French thing

just his personality

Coach Wymack is the only one he knows with experience of helping a former Raven de-transition from the Nest so he'll occasionally call Wymack and give a vague statement to try to see if Wymack has dealt with this with Kevin, while not giving too much away in case it's just a Jean thing.

-

Rhemann: So... some of my kids decided to take classes together, really stick to a buddy system sort of deal

Wymack: Yeah. It's a thing. Kevin's gotten better but he still gets anxious if he's alone.

-

Rhemann: Some of my players are really excelling in language arts. Which is great for their grades, but their imaginative descriptions really toe the line between feedback and a yellow card.

Wymack: Jean, right? Kid speaks three languages that I know of and I think he's most adept at insults in all of them. He had more than a few choice words for me and my team when he was out here.

-

Rhemann: A good thing about California is that it hardly ever rains.

Wymack: That's a good thing? Thought you guys were dealing with a drought.

Rhemann: Yeah, but sunshine and good weather most of the year. People don't have to worry about slick roads or getting wet.

Wymack: I guess?

Rhemann: Water.

Wymack: Hmm, yeah, not sure where you're getting at with this one. Whatever it is, I don't think mine had it.