If you are a Mac user, use ⌃ + ⌥ + Return instead. Start by placing your cursor before the first argument, and press Alt + Enter if you are using Excel for Windows. Based on this assumption, it’s a good practice to group the logical statement and arguments. A new IF function starts with a argument, thus logical statement and arguments share the same properties. Since line breaks mean multiple lines, you might want to adjust the height of the formula bar by holding and dragging the bottom border of the bar.Īlthough each formula structure will contain a different logic, a common nested-IF structure will probably look like this. Let’s see how we can use line breaks to make complex formulas easier to read.įirst, increase the formula bar height. There are 5 IF functions with parameters including a named range, numbers, and strings. Obviously, the formula is hard to understand at first glance.
