coding more neatly

[bigdan]

back when i was doing java code used to get sooo imbedded that we used to make opening and closing brackets on top of each other rather than in one line. eg in quotes (when I put spaces in they get taken out so ive used periods instead)

blah blah
{
...... method X
...... ...... {
...... ...... ...... print(hello)
...... ...... }
}

that's not the best example as ive forgotten all my java, but you get the point. now is there some kinda convention to do this with excel?

i wrote this statement =IF(AND(N12<>N11,N12<>N13),"PROBLEM","")

in this case its small so there's no real need to break it up, but if i were to, how would i do so? first thing is, how would i take the ending bracket to the next line? ive tried to do so, havent been able to.
would you put the condition in one line, the true alternative on the next, the false alternative on the third?

 

[jmthompson]

=if(and(n12<>n11,_
n12<>n13),"problem","")

 

[Norie]

If this is for formulas on a worksheet you can use ALT+ENTER.

If it's code then you can use the continuation underspace as Jen suggests.

 

[bigdan]

yes its formulas on a worksheet. thanks guys.

@norie would you write it the same way as jen?

 

[Norie]

I might do it a bit different but I think that's a kind of personal thing.

I suppose if you were following Java then the closest you could get would be the condition on one line, the if on the next line and then the else on the 3rd.

Though I'm not sure that would look so good.

=IF(AND(N12<>N11,N12<>N13),
"problem",
"")

PS If you are using a lot of nesting it might be worth checking the formula and seeing if it could be done in some other way.