SOLVED

Dividing formula into several lines

%3CLINGO-SUB%20id%3D%22lingo-sub-1399292%22%20slang%3D%22en-US%22%3EDividing%20formula%20into%20several%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1399292%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20i%20write%20a%20formula%2C%20I%20would%20like%20to%20use%20several%20lines%20to%20increase%20the%20readability%20of%20a%20formula.%20I%20am%20aware%20of%20being%20able%20to%20split%20a%20formula%20into%20several%20lines%20using%20ALT%2BENTER%2C%20see%20the%20picture%20below%2C%20although%20am%20I%20able%20to%20tab%20a%20line%2C%20to%20seperate%20formulas%20within%20formulas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20formula%20would%20look%20similar%20to%20this%3A%3C%2FP%3E%3CP%3E%3CFONT%3E%3DIF((IF(TIME(I32%3B0%3B0)%3D0%3B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20TIME(I32%3B0%3B0)%2B1%3B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20TIME(I32%3B0%3B0))%2BG32)%26gt%3B%3D1%3B1%3B2)%3CBR%20%2F%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20372px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192600i64721E6D46DE3E95%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1399292%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1399378%22%20slang%3D%22en-US%22%3ERe%3A%20Dividing%20formula%20into%20several%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1399378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622109%22%20target%3D%22_blank%22%3E%40JonasRKorsholm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20not%20out%20of%20the%20box%2C%20you%20may%20use%20online%20formatters%20like%26nbsp%3B%3CA%20href%3D%22http%3A%2F%2Fexcelformulabeautifier.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fexcelformulabeautifier.com%2F%3C%2FA%3E%26nbsp%3Bor%20search%20for%20add-ins.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1399447%22%20slang%3D%22en-US%22%3ERe%3A%20Dividing%20formula%20into%20several%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1399447%22%20slang%3D%22en-US%22%3EOK.%20I%20will%20look%20into%20that.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20the%20quick%20reply%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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
Highlighted
Best Response confirmed by JonasRKorsholm (Occasional Contributor)
Solution

@JonasRKorsholm 

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

Highlighted
OK. I will look into that.

Thank you for the quick reply