Excel Formulas Not Working?

Excel Formula Help is Here

Excel formulas can be frustrating to understand, especially when you start nesting functions.

understanding excel formulasIf you’ve used Excel for a while you’ve probably experienced the urge to bang your head on the desk in frustration. You may have even succumbed to that temptation. I know I have.

In the video below I share a handful of tips that will enable you to understand any formula and figure out why it’s not returning the value you’re expecting, or even worse, why it won’t let you enter it at all!

Here’s an email one of our members sent after watching this video:

“WOW! I’ve been using Excel a rather long time (mostly self-taught) and never picked up the some of the techniques you showed in this short video. I learned SIX new-to-me techniques just watching this 7-minute show! My coworkers think I’m an “Excel guru” but watching this…I’m nearer a novice!

I almost clicked out of the video when I saw it was troubleshooting formulae – a common enough task for me. But then I saw the tool tip and you moved it! I can’t tell you how many times that thing has gotten in the way, but I didn’t know it was moveable. And the other 5 troubleshooting tips in this video that I didn’t already know – wonderful, wonderful!”

For best viewing quality: press play then 1. click the cog and select 720p HD, and 2. click the icon on the bottom right of the video to view in full screen.

Relieve Frustration Around the World

Do you know anyone else who bangs their head on the desk in frustration with Excel Formulas?

Free the World of Excel Formula frustration – Click to Tweet

Let’s spare the world of Excel Formula frustration. Please click the link above to Tweet this, or scroll down to use the buttons below to share these tips with your friends and colleagues on LinkedIn, Google+1 and Facebook.

Want More?

Now you’re ready to tackle anything check out my Excel Formulas List for new tricks to learn.

Sign up for our free Excel Tips and Tricks Newsletter and get loads more tips like these.

FREE PDF Download
100 Excel Tips & Tricks

Excel Tips & Tricks E-Book
Just enter your details below
* indicates required

We respect your email privacy

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Current ye@r *

Comments

  1. ASHOK JAJAL says

    In the below example my problem is with brokerage figure which is based on 0.01% of turnover, it should not be cross the 40 . even if i will increase buying price, selling price, or quantity , insort if turn over figure come 450000 so brokerage figure should not reach 45 , but below 40 it should be show exact figure ie.39,38,35,31,19,15,9 whatever , i m looking for its excel formula
    Particular Buy Price Sell Price Qty.
    —————————– ————- ———— ——
    100 100 1000
    Turnover 200,000
    Brokerage 0.01% of turnover 20
    Stt Total 25
    Total Tran Charge 7.8
    Service Tax 5.74
    Education Cess 0.11
    Higher Edu Cess 0.06
    SEBI Charges 0.20
    Total Tax and charges 78.91
    Points to Breakeven 0.08

  2. rosa says

    what is wrong with this formula? I am not getting the expected results. Is there something wrong with my Date syntax?

    =COUNTIFS(D2:D7,”complete”,Z2:Z7,”US”,AA2:AA7, “UD”,AD2:AD7, Date <=DATEVALUE("1/31/2013"))

    Thanks in advance for your help :)

    • Mynda Treacy says

      Hi Rosa,

      Is ‘Date’ used here: ‘Date <=DATEVALUE(“1/31/2013″)’ a named range? If so you don’t need it in the criteria. Your criteria is the date inside the parentheses. So your formula probably should be more like this:

      =COUNTIFS(D2:D7,"complete",Z2:Z7,"US",AA2:AA7, "UD",AD2:AD7, <=DATEVALUE("1/31/2013"))

      If that doesn’t work please send me your workbook via the help desk so I can see what is in the other cells being referenced by the formula.

      Kind regards,

      Mynda.