WOO! I am nesting like a Motherf***!

Miscellaneous and Personal Stuff I Must Share
21

I fully expect someone to tell me that this functionality already exists :D.

22

Nesting, no matter how many levels deep or how many levels are on one line, is not spaghetti. Spaghetti is using gotos.

23

10 INPUT A$ “WHAT IS YOUR NAME?”
20 IF A$ = “jjimm” THEN B$ = " is cool." ELSE B$ = " sucks."
30 PRINT A$ + B$
40 GOTO 30

24

Heh…loops are cool.

25

Am I the only one who prefers SAS?

26

=IF(ISERROR(HLOOKUP(B$51,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE)),0,HLOOKUP(B$51,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE))+IF(ISERROR(HLOOKUP(B$52,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE)),0,HLOOKUP(B$52,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE))+IF(ISERROR(HLOOKUP(B$53,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE)),0,HLOOKUP(B$53,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE))+IF(ISERROR(HLOOKUP(B$54,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE)),0,HLOOKUP(B$54,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE))+IF(ISERROR(HLOOKUP(B$55,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE)),0,HLOOKUP(B$55,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE))+IF(ISERROR(HLOOKUP(B$56,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE)),0,HLOOKUP(B$56,forecast!$B$4:$AX$52,NCF!$A248+2,FALSE))

That’s a fairly standard formula that I use every day. It looks nasty, but it gets the job done.

-Belz