Excel - Using F9 to Evaluate Part of a Formula - Episode 474
Microsoft Excel Tutorial - Using F9 to Evaluate Part of a Formula - Daily Dose of Excel.
Welcome to the Learn Excel podcast with your host, Bill Jelen. Today, we have a special guest, Dick, who is a star of the Daily Dose of Excel podcast. If you haven't checked it out yet, make sure to visit www.dailydoseofexcel.com for daily Excel tips from Dick and other MVPs. But for now, let's dive into today's tip from Dick on debugging formulas that return errors.
In this episode, Dick shows us a handy trick for identifying which part of a formula is causing an error. He uses the example of a VLOOKUP formula with a MATCH formula nested inside. When the formula returns #N/A, it's not immediately clear if the error is coming from the MATCH or VLOOKUP function. But by highlighting the portion of the formula and using the shortcut [ctrl + =], Dick is able to evaluate that specific part and determine that the MATCH function is returning the correct value. This leaves the VLOOKUP function as the culprit for the error.
But Dick doesn't stop there. He also demonstrates how to quickly identify the specific issue within the VLOOKUP function by highlighting it and using [ctrl + =] again. In this case, he discovers that the lookup value is incorrect, with a capital "O" instead of the intended "0". A simple edit and [Enter] and the formula returns the correct result. This is a great tip for efficiently debugging formulas and saving time in your Excel work.
I hope you found this tip as useful as I did. Don't forget to visit www.dailydoseofexcel.com for more daily Excel tips from Dick and other MVPs. And make sure to tune in next time for another netcast from MrExcel. Thanks for watching!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Dick Kusleika is our guest podcaster today. Dick is the host of the Daily Dose of Excel. He shows how to troubleshoot formulas by evaluating parts of a formula right in the formula bar. Episode 474 shows you how.
Table of Contents:
(00:00) Introduction to the Learn Excel podcast
(00:16) Host Bill Jelen introduces guest Dick from Daily Dose of Excel
(00:26) Dick shares a tip on debugging formulas that return errors
(01:02) Using [ctrl + =] to evaluate portions of a formula
(01:50) Identifying the source of the error in the formula
(02:37) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Control equals shortcut
Daily Dose of Excel podcast
Debugging formulas
Editing formulas
Evaluating formulas
Highlighting portions of a formula
Learn Excel podcast
Lookup value error
MATCH formula
N/A error
Opening and closing parentheses
VLOOKUP formula
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Смотрите видео Excel - Using F9 to Evaluate Part of a Formula - Episode 474 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MrExcel.com 11 Май 2009, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 451 раз и оно понравилось 2 людям.