Excel IF Statement with ROUNDUP and ISEVEN functions | Evaluate Formula | Excel Advanced

Excel question from one of my YouTube subscribers. This involves an IF statement with custom rounding. We want to round down any numbers that are even with a decimal place. For example, 100.5, 102.5, and 14.5 should round down. 100.5 becomes 100, 102.5 becomes 102, and 14.5 becomes 14. With odd numbers 33.5, 47.5, and 101.5, we round up. 33.5 becomes 34, 47.5 becomes 48, and 101.5 becomes 102. When done, we do not have any odd numbers - only even numbers. To figure this out, we will use the IF function, ISEVEN function, and ROUNDUP function. Also shown are ROUND and ROUNDDOWN functions. We don't need those two functions, but they are shown so you can see how they work. We also Evaluate Formula feature located on the Data tab in Excel. Chapters: 00:00 Introduction 01:31 ISEVEN function 02:34 ROUNDUP function 02:58 ROUNDDOWN function 03:15 ROUND function 04:05 IF statement 06:00 Explanation 07:38 Closing remarks #msexcel #excelfuntion #chrismenardtraining #microsoftexcel And make sure you subscribe to my channel! -- EQUIPMENT USED --------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 -- SOFTWARE USED --------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!