<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Atsaniah Tasnim on Medium]]></title>
        <description><![CDATA[Stories by Atsaniah Tasnim on Medium]]></description>
        <link>https://medium.com/@atsaniah.tasnim?source=rss-321512949328------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*51ygAwg8zjPjhaDgtyJGzA.jpeg</url>
            <title>Stories by Atsaniah Tasnim on Medium</title>
            <link>https://medium.com/@atsaniah.tasnim?source=rss-321512949328------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 15:47:05 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@atsaniah.tasnim/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[If Life Doesn’t Have Inherent Meaning For You, Consider Camus]]></title>
            <link>https://medium.com/culture-club/if-life-doesnt-have-inherent-meaning-for-you-consider-camus-89df8d1cedd9?source=rss-321512949328------2</link>
            <guid isPermaLink="false">https://medium.com/p/89df8d1cedd9</guid>
            <category><![CDATA[nihilism]]></category>
            <category><![CDATA[life]]></category>
            <category><![CDATA[advice]]></category>
            <category><![CDATA[philosophy]]></category>
            <category><![CDATA[book-review]]></category>
            <dc:creator><![CDATA[Atsaniah Tasnim]]></dc:creator>
            <pubDate>Sun, 26 Jul 2026 12:19:35 GMT</pubDate>
            <atom:updated>2026-07-26T12:19:35.571Z</atom:updated>
            <content:encoded><![CDATA[<h4>BOOKS</h4><h4>‘The Myth of Sisyphus’ might be a book you want to read next</h4><figure><img alt="A man pushes a giant boulder up a hill" src="https://cdn-images-1.medium.com/max/1024/1*SU5ebXBM3vfE3JrSVi8haQ.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@vicky49?utm_source=medium&amp;utm_medium=referral">Vicky Sim</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>I still recall the obscure path to reading <em>The Myth of Sisyphus.</em></p><p>I’d just finished watching a psychological thriller anime called <em>Monster</em>. For several reasons, the villain, Johan Liebert, was really interesting to me.</p><p>The main reason? The author never discloses Johan Liebert’s mind, psychological state or motives when committing his cruel crimes. Instead, manga readers and anime viewers could only see flashback scenes about Johan Liebert. This provided a space for fan discussions where readers could actually find out who exactly “Johan Liebert” was.</p><p>As I read across discussions, lingering on the internet, I came across the term “nihilism.” Looking it up, I found that nihilism is a philosophical belief that life lacks inherent meaning, purpose, or intrinsic value.</p><p>“<em>Well, that is interesting,</em>” I thought.</p><p>I decided to read further, partly because that was how I’d been feeling about life lately. My curiosity grew, and wanting to know more about nihilism itself, I looked for a book to read to better understand nihilism.</p><p>Long story short, I found a few recommendations from Quora and Reddit, one of which was <em>The Myth of Sisyphus</em>. People said it was one of the best books for starting to understand nihilism. This book, though, drew my attention because it talks about the progression of nihilistic values, which are the existential crisis and absurdity, and how we can live with it.</p><p>I realized, this book might actually help me find how to live this life more fully.</p><h4>More about the book</h4><p><em>The Myth of Sisyphus</em> is an essay written by Albert Camus, one of the popular philosophical writers from the mid-20th century era, that is printed, sold, and read as a standalone book. He discusses Sisyphus from Greek mythology and links it with the existential crisis and absurdity.</p><p>Camus states that absurdity starts when there is a “divorce” between a man’s idealism and reality. Men reacted differently when they were presented with absurdity. Some resolved to take their own life — which Camus ultimately rejects — but some came to an understanding and accepted the absurdity to go on with their lives. He uses the Greek legend of Sisyphus, who is condemned to eternally push a boulder up a hill only to watch it roll back down, as a metaphor for the human condition.</p><p>The main thing to highlight here, Camus does not conclusively say that men should find meaning in their lives. Instead, he argues that while life is inherently meaningless, we must accept and find joy in this struggle anyway. Just as he concluded it in the book, which is also infamously the most cited by people:</p><blockquote>The struggle itself toward the heights is enough to fill a man’s heart. One must imagine Sisyphus happy.</blockquote><h4>My favorite quote</h4><p>I have read the whole book, and surprisingly my favorite quote is less talked about on the internet — at least that&#39;s what I see (and correct me if I am wrong.)</p><p>Particularly, this sentence has left a huge impact on how I should look at my life moving forward:</p><blockquote>If the descent is thus sometimes performed in sorrow, it can also take place in joy.</blockquote><p>The term “descent” can mean both the hardship and joy. How? The descent, as a hardship, metaphorically can mean a loss of status/stability, a psychological breakdown, or a painful moment. The descent, as a joy, can also refer to that one time after Sisyphus completed the labor of pushing the boulder up to the hill and saw the boulder going down again.</p><p>In this moment, the walk back down is when Sisyphus can pause and think so clearly. This moment to think is clearly a joy in its own sense.</p><p>This sentence is so powerful because, if we look at life, it goes up and down — very dynamic. Sadness and sorrow come and go, just like how joy and happiness do. However, the way we face those is a part of our choice. We can still choose to feel grateful and remain positive while hardships hit us. We can also choose to frown and feel not enough even when we already achieve what we want. In the end, it’s only a matter of our choice to actually feel full and happy about our own life.</p><h4>How this book changes the way I look at my life</h4><p>I have to admit that I am a pessimist. I don’t see any necessity in living until I’m very old. I keep thinking that I am a side character that doesn’t have any impact on any storyline in this world. I’m just a piece of dust — if I could say. I even think that if my destiny is to die young, I would not mind it at all.</p><p>For a long time, I’ve been searching for the meaning of my life, the happiness, and the joy in my life. I’ve seen many people living their lives to the fullest. In the meantime, I keep trying to find something bigger. A bigger meaning in my life. A bigger role for me in the world to explain why I still live until now. That journey of finding grand meaning to my life has divorced me from reality, and eventually I got tired, for my whole life.</p><p>After reading this book, I realize that a meaning in life is not always about something big, or impactful, or grand, or splendid. A meaning of life can exist even for the tiniest part of this life. To simply exist for your family, your friend, your pets, your favorite food, your favorite artists, can also be the meaning of life.</p><p>In this moment, I proudly say that I still cannot tell what exactly the meaning of this life is, what my role is in this life.</p><p>But hey, it is okay! I still choose to enjoy every little moment given to me, whether it is painful, pleasant, sad, or happy — with tears, smiles, crying, and laughter. I want to fill the empty jar of my life with every moment and treasure it until my number is up.</p><h4>Who I would recommend this book to</h4><p>Completing this book, I could say it is quite easy to understand. Many book publishers have translated this book too, so I am sure that you can find one in your language quite easily.</p><p>If you are interested in philosophy in general, or specifically nihilism, or simply think that this life is meaningless, <em>The Myth of Sisyphus</em> may be of interest to you. I’m sure you can learn a lot and get an interesting perspective on the existential crisis and nihilism, and how to still embrace life afterwards.</p><h4>Last thing from me</h4><p>One thing to note from this book is that when we find ourselves in the state of nihilism, the answer does not always lead to suicide — an option that Camus ultimately rejects — because we can still choose to live even when we know that life has no inherent meaning.</p><p>In the end, if we somehow experience nihilism in our lives, just know that there is literally no pressure to find the meaning of our life immediately or at all. Instead, we can take our time to feel that absurdity and crisis, ponder through it, and choose which path we want to go.</p><p>Even if we decide not to search for the meaning of life itself, we can always carry on with our lives and fill that emptiness with joy and happiness — even the smallest ones — that we already choose to feel and have.</p><p>If we do find the meaning of this life, then we can continue to sincerely live our lives to the meaning we’ve concluded. That being said, I found this book truly inspiring — it taught me a lot about how I should look at my own life and which path is available for me to move forward.</p><p>I started as someone who was empty, lost, and desperate, but now I can feel that I am starting to experience, enjoy, and appreciate things in my life a lot more. I’ve decided to look at that emptiness as a blessing, where I can always fill it up with things I love and am passionate about.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=89df8d1cedd9" width="1" height="1" alt=""><hr><p><a href="https://medium.com/culture-club/if-life-doesnt-have-inherent-meaning-for-you-consider-camus-89df8d1cedd9">If Life Doesn’t Have Inherent Meaning For You, Consider Camus</a> was originally published in <a href="https://medium.com/culture-club">Culture Club</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[No Clipping Nails at Night, The “Pamali” of Indonesians]]></title>
            <link>https://medium.com/@atsaniah.tasnim/no-clipping-nails-at-night-the-pamali-of-indonesians-2efe0cdf57ec?source=rss-321512949328------2</link>
            <guid isPermaLink="false">https://medium.com/p/2efe0cdf57ec</guid>
            <category><![CDATA[the-writers-circle]]></category>
            <dc:creator><![CDATA[Atsaniah Tasnim]]></dc:creator>
            <pubDate>Thu, 23 Jul 2026 16:25:29 GMT</pubDate>
            <atom:updated>2026-07-23T17:07:32.124Z</atom:updated>
            <content:encoded><![CDATA[<p>The word “pamali” in Indonesian refers to any traditional taboos or unwritten prohibitions within society.</p><p>There are a lot of interesting ones, but the most interesting one may fall into this “pamali”:</p><blockquote>Jangan potong kuku malam hari, nanti umurmu bisa makin pendek.</blockquote><p>Or, in English:</p><blockquote>Do not clip your nails at night, or it will shorten your life.</blockquote><p>This “pamali” is often said by parents to their kids from the 80s to the 2000s. When kids hear about this, they obviously refrain from clipping their nails at night because they want to live longer, for sure!</p><p>However, there’s a twist behind this “pamali”.</p><p>The reason why people said not to clip their nails at night was that electricity and lamps were not so common in houses. People still used oil lamps, which did not provide much light at night.</p><p>See where this is going?</p><p>Yup! Hence why no clipping nails at night, because you might cut your fingers or toes. Or, maybe people just tried to save oil for the lamp.</p><p>However, people might still be stubborn enough to do so; that’s why they wrapped it with even more scary things for them at that time. Die at a young age.</p><p>As electricity became more common in Indonesia around the 90s — 2000s, people started leaving this “pamali” or so-called social ritual as it is no longer relevant.</p><p>In the end, no one knows whether someone will die young or old.</p><p>Have you ever heard about any other unwritten prohibitions that are interesting in your country?</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2efe0cdf57ec" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Farewell to Love and Relationships]]></title>
            <link>https://medium.com/@atsaniah.tasnim/the-farewell-to-love-and-relationships-1f2ac37e1202?source=rss-321512949328------2</link>
            <guid isPermaLink="false">https://medium.com/p/1f2ac37e1202</guid>
            <category><![CDATA[thewritercircle]]></category>
            <dc:creator><![CDATA[Atsaniah Tasnim]]></dc:creator>
            <pubDate>Fri, 26 Jun 2026 05:06:16 GMT</pubDate>
            <atom:updated>2026-06-26T05:10:59.615Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/820/1*qmZB71rA17B-DWANfvVz4g.jpeg" /></figure><p>It was afternoon. The sun was shining bright and the wind brushed through my hair. I just finished my school, I was just an 8-year-old ugly little girl who just moved to this village a few months ago. That day, I rode a bicycle passing a boy sitting at the right side of the road. He held a wooden stick. Then, without any warning, without any words, he hit my right shank hardly enough that it returned a sharp snapping sound. I didnt’t know what to do. I was scared, it was painful. I could feel the stings. However, I could not stood up to myself. I was just a shy kid in an unfamiliar place. I only continued riding my bicycle to home while holding my tears so it didn’t fall onto my cheeks. That day, I learned that male can be scary.</p><p>In another morning, I got ready to go to school but I couldn’t find my eraser. As a kid, I was expressive. I cried and asked for help. However, I guess that was a nuisance for my dad. With anger and frustation, he yelled at me, told me to shut up. He even picked up a broom and almost hit it to me. I was scared and startled. I cried even harder and ran away from the home. A friend of my mom saw me ran away from the house while wailing. She chased me and calmed me down. I didn’t remember further if I ended up going to school or not that day. It was not my parents who showed care and concern to me. It was someone else who was not even my blood-relative. That day, I learned that male can be repressive.</p><p>Fast forward to my middle school time. I was verbally bullied by a male classmate. Naturally, I am an unattractive brown-skinned skinny girl. Well, I figured that the way I look was not up to the decent appearance according to the beauty standards around me. Then, there was this one boy, who kept mocking my skin color, calling me with stereotype, stigma, and discrimination for people with dark-skin color in my neighbourhood. He didn’t direclty say I was ugly. However, he did make fun of it by implying a lower social status. At first, I thought that was how you made friends and that was just how people joke. However, as time went, hearing that same words everyday, I became less and less confident. One day, I got really tired of the bullying. I chose to stand up for myself. Right when this boy bullied me again, I answered bravely and mocked him back. That was immature — I know. However, that was the only time I had my courage to speak up for myself and, only that one time, I mocked this boy , who had been mocking my appearance for a few months — I’d never done it before. The twist is this boy got mad to me for mocking him. He was even ready to threw fist at me. He was ready to punch me. When I say punch, he literally clenched his fist and was ready to hit me with that. I was flabbergasted. I only wanted to stood up for my self for once and that was the thing I saw as the consequences for doing what was right for me. That day, I learned that male can be ready to hit you whenever to talk back to them.</p><p>I know very well that I should not judge that all men are the same. However, with those experiences, I subconsciously think that male is a threat and I have had enough to get involved with male. From then on, I try to limit my interaction with men. I do still interact with them but I can no longer put my full trust to them and I always put a good distance with them to not get too close with them. The biggest scar and pain I felt was from my dad — imagine someone who should protect you, ended up yelling at you and tried hitting you.</p><p>Eventually, as I grow older, know about love and see other people start dating, I keep on thinking what exactly is love. How they can fall in love with a man. Love means that you give your trust to the loved one and for me, I don’t know how I can put my trust to a man because all I know is that men are scary.</p><p>In the end, up until now, I haven’t been able to be in a relationship with a man and I don’t bother even searching for them. All this time, the one that is always with me is always myself. Everytime I cry, I am with myself. So yeah, I’ve let go of dating, loving, and having relationship with men.</p><p>I do not hate men. I am not trying to be a feminist or degrading men whatsoever. It is just that I have not been able to find a way to trust them with all of my heart.</p><p>I’m curious about your thoughts, though.</p><blockquote>What do you think love and relationship means?</blockquote><blockquote>If you’ve ever lost the trust to men (or women) and managed to regain it back, what is the reason behind that?</blockquote><p>I’d love to know and hear your stories!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1f2ac37e1202" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Cleaning Challenge #1: Valid/Invalid Email Addresses]]></title>
            <link>https://medium.com/@atsaniah.tasnim/data-cleaning-challenge-1-valid-invalid-email-addresses-3ce341c9280e?source=rss-321512949328------2</link>
            <guid isPermaLink="false">https://medium.com/p/3ce341c9280e</guid>
            <category><![CDATA[regular-expressions]]></category>
            <category><![CDATA[data-validation]]></category>
            <category><![CDATA[data-cleaning]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Atsaniah Tasnim]]></dc:creator>
            <pubDate>Tue, 21 Apr 2026 22:01:01 GMT</pubDate>
            <atom:updated>2026-05-07T07:31:26.698Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Thumbnail — Post #2" src="https://cdn-images-1.medium.com/max/1024/1*Fj79g1ZFZgQ0dzQPv-6OZQ.png" /></figure><p>Raw data is almost never ready to use. If the data is small, it can be quickly structured, but how about a large dataset? It can take hours to clean and structure them.</p><p>This is why I’m learning how to clean data using Google Sheet functions. After learning Google Sheets for about a week, I understand that there are lots of functions we can use to clean up data automatically.</p><p>In this project, I created a mock 500-row e-commerce dataset using AI tools and simulated the data cleaning process with it.</p><h4>Step 1: Checking the data</h4><p>Before we move forward, feel free simulate and practice with me. You can first make a copy of the dataset right here ▶️ <a href="https://docs.google.com/spreadsheets/d/1i9O9zLwMGYEvM2e9sd7R9i0h1JUWAyLTOzSYuVqAG_s/edit?usp=sharing"><strong>Raw Dataset</strong></a></p><p>At first glance, the data is completely raw, so to ease reading the data, I first create a copy of the raw data.</p><figure><img alt="Duplicating a sheet" src="https://cdn-images-1.medium.com/max/888/1*3ChGZTbr5UVsPbeyRO50og.png" /></figure><p>Then, I split the data into columns and ensured that:</p><ul><li>Each column contained only one type of data</li><li>No merged or misaligned values</li></ul><figure><img alt="Splitting text into columns" src="https://cdn-images-1.medium.com/max/883/1*TTak2wQdkpLaA8BzJgqL1w.png" /></figure><p>The data looked abit better right after and I started scanning the data.</p><figure><img alt="After splitting columns" src="https://cdn-images-1.medium.com/max/1024/1*bGMWKxJ_iB5tl-X4dFqi7A.png" /></figure><p>From here, several issues became clear:</p><ol><li>Invalid emails</li><li>Missing product names</li><li>Inconsistent product names, categories, payment methods, and statuses.</li><li>Mixed date formats.</li><li>Pricing inconsistencies (`100k`, `250k`, numeric values)</li><li>Suspicious values (e.g., quantity = 0 or 999)</li></ol><p>My goal here was simple, which is to transform this messy dataset into a clean, structured, and analysis-ready dataset.</p><p>And for now, I am going to focus on “<strong>fixing the invalid emails”.</strong></p><p>If you’ve made the copy of the dataset above, let’s work on it together!</p><h4><strong>Step 2: Categorizing Valid Emails</strong></h4><p>In this dataset, I see that emails had multiple invalid formats, such as kevinlee@gmail, agussalim, and many more.</p><p>To validate emails, I used a formula that checks whether each value follows a standard email format (e.g., name@domain.com). Instead of manually reviewing hundreds of rows, this approach quickly identifies which emails are valid or invalid based on their structure.</p><p>In this case, I used a REGEXMATCH formula and combined it with the IF formula to classify emails into:</p><ul><li>Valid</li><li>Invalid</li></ul><p>Before moving forward, we should now how the email patterns look like. In this case, I divided the email patterns into four specific parts:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bdBUagncXjJaw85mV1jpWQ.png" /></figure><ol><li><strong>Username </strong>▶️ The first part of email which identifies the specific mailbox or user. Uses alphabets (a-z), digits(0–9), underscores (_), dots(.), percent(%), plus (+), dash/hypen ( — ).</li><li><strong>At (@) sign </strong>▶️Separates the local part from the domain part.</li><li><strong>Second-level domain </strong>▶️ The unique name registered by an organization or individual. It can contain alphabets, digits, dot, and hyphen. For example, gmail, yahoo, mail.example, etc.</li><li><strong>Top-level domain </strong>▶️ The extension at the end of the domain. Examples: .com, .org, .net, .id, .edu.</li></ol><p>From here, I determined that there are some parts that can be filled randomly, which are<em> the username, the second-level domain, and the top-level domain.</em></p><p>That’s said, these parts can be written by using Regex shorthand class, specifying the alphabets, digits, and specific characters inside brackets ( [] ).</p><p>This is the Regex pattern for the email addresses:</p><pre>^[\w.%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$</pre><blockquote>To get this patter, I firstly practiced regular expression in these two sites: <a href="https://www.benlcollins.com/spreadsheets/google-sheets-regex-formulas/">REGEX cheat sheet</a>; <a href="https://regexone.com/">REGEX exercises</a>.</blockquote><p>Here’s the break down to understand the pattern further:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ez9lV72bXDpHJPC2hxajRA.jpeg" /><figcaption>Regex Patterns for Email Addresses along with its explanations</figcaption></figure><p>And, now that I’ve got the Regex patter, I implemented it to the IF formula. Here’s the formula I use:</p><pre>=IF(REGEXMATCH(C2,&quot;^[\w.%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$&quot;),&quot;VALID&quot;,&quot;INVALID&quot;)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KvqSAvCsubWzy_Bt1rGT7g.png" /></figure><p>Let’s break it down:</p><ul><li>REGEXMATCH is added as a condition. The main purpose is to match the cell with the email pattern specified by regular expression.</li><li>IF function is to make a decision, whether the email is valid or not based on the REGEX condition.</li></ul><p>After using the formula, you should see the value to show “valid” for correct email pattern (name@domain.com), and “invalid” for incorrect email pattern (name, name@domain)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/348/1*96AObHrMy28WPYP9JKx_xw.png" /></figure><p><strong>Friendly reminder:</strong> don’t forget to apply the formula to all 500 rows in the sheet 😉</p><h4>Step 3: Apply Conditional Formatting/Data Validation</h4><p>Next, just to make the data prettier and more neat, we can apply conditional formatting or data validation to the email validation column.</p><p>I’ll show you how to do that — but really, you can choose whichever one you prefer in your sheet.</p><p>First, let’s try the conditional formatting.</p><p>Select the Email validation column. At the top bar, open Format ➡️ Conditional formatting.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/742/1*aONfArlbQ2OX8k52DZHyfA.png" /></figure><p>Here are things you need to update:</p><ol><li>“Apply to range” field — update the range to D2:D (to exclude the header row and apply the format to all D columns)</li><li>“Format rules” field — change the rule to “Is equal to”</li><li>Lastly — write “Valid” as the value.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/516/1*fBjn6Xw3nMdn-ur9nXCIvA.png" /></figure><p>Now, any cells that have “Valid” value will be in green colour format.</p><p>You can do the same for the invalid emails. But this time, use the value “Invalid” instead and change the colour to red or other colour of your preference.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/432/1*VeZkMJJw2X65hBp3LdWvOw.png" /></figure><p>And that’s it!</p><p>Now, using the data validation.</p><p>For this, you can select the Email validation column first. Then, at the top bar, go to Data ➡️Data validation</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/816/1*NJtNkltO8DAK8vGuqyHiwg.png" /></figure><p>Click +Add rule.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/459/1*RbjG8_OGUJCclm_4jsoxAA.png" /></figure><p>In the “Apply to range” field, update the range to D2:D.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/442/1*_l16FrhIAazBTH4dwZhSUg.png" /></figure><p>Remove the “Email validation” criteria.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/454/1*U-G8z4aXVrBuxeG5BmM1ZQ.png" /></figure><p>For the last touch, you can simply change the colour of each criteria. Here, I use green for “Valid” and red for “Invalid”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/427/1*uSZInQS5J3oG-7-ySVSwjA.png" /></figure><p>Voila! Your email validation data is now good to go.</p><p>In the next blog, I’m going to show you how to fix inconsistent product names, categories, payment methods, and statuses using the same dataset. So, stay tune!</p><p>In the meantime, feel free to let me know if you have any questions or found a better way of doing this. I’m open to any feedback 😊</p><p>Thanks for reading all the way down here. See you!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3ce341c9280e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Understanding the IFS Logic: Avoiding Small Mistake in Google Sheets That Cause Wrong Data…]]></title>
            <link>https://medium.com/@atsaniah.tasnim/understanding-the-ifs-logic-avoiding-small-mistake-in-google-sheets-that-cause-wrong-data-a97ac7c2df03?source=rss-321512949328------2</link>
            <guid isPermaLink="false">https://medium.com/p/a97ac7c2df03</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Atsaniah Tasnim]]></dc:creator>
            <pubDate>Fri, 10 Apr 2026 11:49:58 GMT</pubDate>
            <atom:updated>2026-04-10T11:49:58.671Z</atom:updated>
            <content:encoded><![CDATA[<h3>Understanding the IFS Logic: Avoiding Small Mistake in Google Sheets That Cause Wrong Data Categorization</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ks_ljrgMl2z6NuddquBr9w.jpeg" /></figure><p>While learning Google Sheets, I came across a small but important behaviour in the IFS function. One that can easily lead to incorrect data categorization if misunderstood.</p><p>At first glance, IFS looks simple. But the way it evaluates conditions can silently introduce errors into your dataset.</p><p><strong>What is IFS?</strong></p><p>The IFS function in Google Sheets is used to evaluate multiple conditions and return a value based on <strong>the first true condition.</strong></p><p><strong>=IFS(condition1, value_if_true1, condition2, value_if_true2, and so on…)</strong></p><p>It is a cleaner alternative to nested IF statements. So, instead of writing something like:</p><pre>=IF(A1&gt;90,&quot;A&quot;,IF(A1&gt;75,&quot;B&quot;,IF(A1&gt;60,&quot;C&quot;,&quot;D&quot;)))</pre><p>You can simplify it using IFS:</p><pre>=IFS(A1&gt;90,&quot;A&quot;,A1&gt;75,&quot;B&quot;,A1&gt;60,&quot;C&quot;,TRUE,&quot;D&quot;)</pre><p>This makes formulas easier to read, write, and maintain, especially when working with multiple categories.</p><p><strong>How IFS actually evaluates your data</strong></p><p>Sample:</p><p><strong>= IFS ( condition1 , “A” , condition2 , ”B” , condition3 , “C” )</strong></p><p>Let’s take a look how IFS evaluates:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dW8q00VjUQmZd92fgdtkyQ.jpeg" /></figure><p><strong>The Use Case</strong></p><p>I was working with a simple dataset categorizing speed values:</p><ul><li>≤50 → SLOW</li><li>51–90 → NORMAL</li><li>90 → FAST</li></ul><p>Here’s a sample:</p><p>Bulbasaur → 45 → SLOW</p><p>Charizard → 100 → FAST</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/609/1*xIQ2Uae88ES8yt7JamZFCQ.png" /></figure><p><strong>The Working Formula</strong></p><pre>=IFS(C2&gt;90,&quot;FAST&quot;,C2&gt;50,&quot;NORMAL&quot;,C2&lt;=50,&quot;SLOW&quot;)</pre><p>This works correctly because conditions are evaluated from highest to lowest. No incorrect overlaps affect the result.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XoW4Hg6X-_u1GfWg9a8Z8g.png" /></figure><p><strong>The Problematic Version</strong></p><p>I then tried reversing the logic:</p><pre>=IFS(C2&lt;=50,&quot;SLOW&quot;,C2&gt;50,&quot;NORMAL&quot;,C2&gt;90,&quot;FAST&quot;)</pre><p>At a glance, this seems fine.</p><p>However, this introduces a subtle bug.</p><p>Let’s take a value of 100:</p><ul><li>C2&lt;=50 → FALSE</li><li>C2&gt;50 → TRUE ✅</li></ul><p>The correct value for 100 → “FAST”</p><p>However, at this point, IFS returns “NORMAL” and stops evaluating further conditions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rM3TmXeXtRCh-l1URYe2fQ.png" /></figure><p>👉This means that it never reaches C2&gt;90</p><p><strong>Key Insight</strong></p><p>IFS evaluates conditions from left to right and stops at the first TRUE condition. This means overlapping conditions can override more specific logic.</p><p><strong>The Correct Fix</strong></p><p>To solve this, conditions must be mutually exclusive:</p><pre>=IFS(C2&lt;=50,&quot;SLOW&quot;,C2&lt;=90,&quot;NORMAL&quot;,C2&gt;90,&quot;FAST&quot;)</pre><p>Now, all data returns the correct value as required:</p><ul><li>≤50 → SLOW</li><li>51–90 → NORMAL</li><li>90 → FAST</li></ul><p>There is no overlap or conflict.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XG550LIhy_tG65uOs2kCJw.png" /></figure><p><strong>Best Practices</strong></p><p>When using IFS, I recommend following one of these:</p><ol><li>Order from highest to lowest:</li></ol><pre>&gt;90 → FAST<br>&gt;50 → NORMAL<br>&gt;=50 → SLOW</pre><p>2. Use strict ranges:</p><pre>&lt;=50<br>&lt;=90<br>&gt;90</pre><p><strong>Why This Matters</strong></p><p>This kind of issue can quietly affect:</p><ul><li>Reports</li><li>Dashboards</li><li>Data analysis</li><li>Automation workflows</li></ul><p>And the worst part it you might not notice it immediately, especially when the data is huge.</p><p><strong>Final Thought</strong></p><p>This behaviour is subtle, but once you understand it, you’ll start noticing how easily overlapping conditions can lead to incorrect results, especially in real and large datasets.</p><p>That is why, understanding how functions evaluate logic is just as important as writing them.</p><p>A small detail like condition order can be the difference between accurate insights and misleading data.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a97ac7c2df03" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>