SOLVED

# Dividing formula into several lines

Highlighted
Occasional Contributor

# Dividing formula into several lines

Hi

When i write a formula, I would like to use several lines to increase the readability of a formula. I am aware of being able to split a formula into several lines using ALT+ENTER, see the picture below, although am I able to tab a line, to seperate formulas within formulas?

So the formula would look similar to this:

=IF((IF(TIME(I32;0;0)=0;
TIME(I32;0;0)+1;
TIME(I32;0;0))+G32)>=1;1;2)

2 Replies
Highlighted
Best Response confirmed by JonasRKorsholm (Occasional Contributor)
Solution

# Re: Dividing formula into several lines

That's not out of the box, you may use online formatters like http://excelformulabeautifier.com/ or search for add-ins.

Highlighted

# Re: Dividing formula into several lines

OK. I will look into that.

Thank you for the quick reply