May 18 2020 06:43 AM
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)
May 18 2020 06:57 AM
SolutionThat's not out of the box, you may use online formatters like http://excelformulabeautifier.com/ or search for add-ins.
May 18 2020 07:22 AM
May 18 2020 06:57 AM
SolutionThat's not out of the box, you may use online formatters like http://excelformulabeautifier.com/ or search for add-ins.