It’s quite evident that we often write lengthy excel formulas to execute complex logic’s, but as you know it’s very hard to debug in case if you have any errors.

So, the best and easiest way is to break down formulas by each logic by using Alt+Enter in the formula bar. With the help of below example, you can see yourself the benefits breaking formulas.

One of our Commission calculation formulae will look like below before and after using this technique: (see figure 1)

Breakdown lengthy formulas

 

 

 

 

 

 

 

 

I guess by this time you would have understood the relevance of using formula breakdown method.

For a full content or more Tips & Tricks follow the link: https://plus.google.com/collection/YeJ9ME

Public Courses delivered in our Amelia ST Office, just opposite the Europa Hotel in Belfast City Centre.
Courses can be Delivered on Your Own Premises with the Following Provided at NO EXTRA CHARGE:
• Up To 10 Laptops
• LCD Projector
• Projector Screen & Flipchart
Click here for more info: https://www.mullantraining.com/
Call, Email or Chat Live with an Account Manager now:
T: +442890322228
E: info@mullantraining.com
W: www.mullantraining.com

#ITCourse #NorthernIreland

 

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks