Saturday, September 17, 2011

11. =IF(logical test, [value_if_true], [value_if_false])

Okay, guys… Am totally about to geek-out on you this morning…

But I seriously woke up thinking about how the “=IF” function in Excel applies to my life. This is a true statement.

Excel is about as “math-y” as I get. Really it’s just a big, fancy calculator on a grid.

The way functions work in Excel seems magical to me. And I love magic.

So my subconscious is making magical calculations in my sleep? 

So be it.

Let me explain… Stay with me now... 

The “=IF” function in Excel checks whether a condition is met in a certain cell and then, in another cell, returns one value if that condition is “True,” and returns another value if that condition is “False.”

I do this to test my beliefs.

In Excel…
=IF(logical test, [value_if_true], [value_if_false])

In my head…
=IF(I am powerful beyond all measure, [I should believe this statement and live my life as if I am a powerful person that can make an impact for good in the world], [I should disbelieve this statement and live my life shrinking in fear, feeling powerless and focusing only on my own weakness and self-protection])

Hmmmm? Which value would I rather choose? The [value_if_true] or the [value_if_false]?

TRUE! Clearly serves me better. No question.

And this function can and has applied to soooo many areas of my life…

=IF(I deserve to have a loving relationship that brings joy and growth into my life every day, [I should believe this statement and take great care in allowing someone into my life who will love me unconditionally and will allow me to love him unconditionally and I will not settle for anything less], [I should disbelieve this statement and fearfully cling to any relationship, even if it negatively affects my life, because I am lucky to have someone, anyone paying attention to me and the thought of being alone scares the crap out of me])

=IF(My time is valuable and I am capable of supporting myself financially on my own, [I should believe this statement and know the specific amount of money I need to make in order to live the lifestyle that feels best for me and continue to search for work until I find a job that will give me that amount of compensation so that I will never have to stress-out about how I will be able to afford to pay my bills], [I should disbelieve this statement and take the first job that comes my way even though it really doesn’t pay me enough to be able to survive but it’s better than nothing and looking for a new job is scary and takes effort so I’ll just stay with this one that really doesn’t serve me because I don’t feel confident that it is actually possible to get paid the amount of money I need to be making anyway])

My Body…
=IF(I have a healthy/sexy/beautiful body that I feel great in, [I should believe this statement and make healthy food and exercise choices every single moment to continue to support the health and longevity of my body because I am strong enough to take responsibility for my own choices and my body is a precious gift that I have been given and I love myself and I enjoy the feeling of satisfaction that I get from taking great care of it], [I should disbelieve this statement and know that no matter what I do I will never be able to feel great in my body so it doesn’t matter that I eat unhealthy because changing my behavior with food is too hard for me and I can’t make it a priority to exercise because I don’t have time and even when I do exercise it never actually makes me feel any better anyway so there is no point in trying because I am just going to fail and feel worse])

Applying to Grad School...
=IF(I am worthy of acceptance to the graduate school of my choice, [I should believe this statement and fearlessly move forward and apply myself doing everything I can to prepare the best way I know how to become the kind of student that I would respect and admire and want to be in class with because I am dedicated and talented and passionate and have gifts to contribute to the world and it would be a shame for me to waste my life away sitting behind a computer for the next 30-50 years], [I should disbelieve this statement and give up trying because I have failed twice already and that must mean that I am not talented enough to get in and maybe I'm not actually any good at acting anyway and trying a third time and failing will be so devastating and embarrassing that I may spontaneously-combust and I will forever be known as that loser who tried and failed three times and then burst into flames of inadequacy and it's dumb to follow your dreams anyway because dreamers are silly people that delude themselves into believing things that are never going to happen and though other people are sometimes lucky and get into those schools I will never ever be accepted and I shouldn't even try])


Jump into my head, people! Ha!

I love the “=IF” function. Who knew it would be so applicable in non-math too?!

And it definitely helps to write out the false statement. Because it always sounds so silly when you read what you’ve written and you know that it’s SOOOO clearly false, but sometimes it sounds true in your head.

Disempower the false!!! Write it out!

Essentially, I ask myself… If this is true, what else is true?

Annnnd… as I am able to make tiny changes to improve one area of my life… those skills, that confidence, that momentum can lead to improvements in the other areas of my life as well.

Do your own logical test. What’s your “=IF” Function?

(Geekiness. Done. Close parentheses.)


"Our deepest fear is not that we are inadequate. Our deepest fear is that we are powerful beyond measure. It is our light, not our darkness that most frightens us.' We ask ourselves, Who am I to be brilliant, gorgeous, talented, fabulous? Actually, who are you not to be? You are a child of God. Your playing small does not serve the world. There's nothing enlightened about shrinking so that other people won't feel insecure around you. We are all meant to shine, as children do. We were born to make manifest the glory of God that is within us. It's not just in some of us; it's in everyone. And as we let our own light shine, we unconsciously give other people permission to do the same. As we're liberated from our own fear, our presence automatically liberates others."
(Williamson, Marianne. A Return to Love: Reflections on the Principles of "A Course in Miracles", Harper Collins, 1992. From Chapter 7, Section 3])


  1. LOVE this... and I know virtually NOTHING about excel (other than it scares me a bit). Brilliantly thought out my dear friend!

  2. Genius and totally rad. I could DEFINITELY use this in my life... You make it seem so easy. I think I might need some help. Any takers?!

  3. Alexis, it is totally NOT easy at ALL. So know that, first of all....And second of all, I am always here as resource for you if you need me. Love you, lady!

  4. Thank you, Rieker, for your kind comment! Excel is a bit scary, yes. I must admit.