How to Write an IF Function in Power Query Including Nested IFs

Опубликовано: 22 Январь 2019
на канале: Computergaga

129,633

1.2k

The IF function is one of the most useful in Excel. In this video we look at how to write an IF function in Power Query.

The video includes three examples. Firstly a typical IF function added as a custom column. Then we combine the If function with Or logic. Then we finish we a nested IF example.

The video will cover the key differences between writing formulas in Power Query and in worksheets.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ►   / 18737946
Instagram ►   / computergaga1
Twitter ►   / computergaga1