SOLVED

Dividing formula into several lines

Copper Contributor

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)

 

Capture.PNG

 
 

 

 

2 Replies
best response confirmed by JonasRKorsholm (Copper Contributor)
Solution

@JonasRKorsholm 

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

OK. I will look into that.

Thank you for the quick reply
1 best response

Accepted Solutions
best response confirmed by JonasRKorsholm (Copper Contributor)
Solution

@JonasRKorsholm 

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

View solution in original post