# WOO! I am nesting like a Motherf\*\*\*! **URL:** \ **Category:** Miscellaneous and Personal Stuff I Must Share\ **Created:** [March 22, 2006, 8:55pm UTC](https://boards.straightdope.com/t/woo-i-am-nesting-like-a-motherf/349480 "2006-03-22T20:55:27Z")\ **Posts on this page:** 6\ **Page:** 2
**Author:** ![Richard\_Pearse](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/richard_pearse/32/13144_2.png) [@Richard\_Pearse](https://boards.straightdope.com/u/Richard_Pearse)\ **Post date:** [March 23, 2006, 11:27am UTC](https://boards.straightdope.com/t/woo-i-am-nesting-like-a-motherf/349480/21 "2006-03-23T11:27:40Z")
I fully expect someone to tell me that this functionality already exists :D. ---
**Author:** ![cmkeller](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/cmkeller/32/118_2.png) [@cmkeller](https://boards.straightdope.com/u/cmkeller)\ **Post date:** [March 23, 2006, 3:18pm UTC](https://boards.straightdope.com/t/woo-i-am-nesting-like-a-motherf/349480/22 "2006-03-23T15:18:17Z")
Nesting, no matter how many levels deep or how many levels are on one line, is not spaghetti. Spaghetti is using gotos. ---
**Author:** ![jjimm](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@jjimm](https://boards.straightdope.com/u/jjimm)\ **Post date:** [March 25, 2006, 10:20am UTC](https://boards.straightdope.com/t/woo-i-am-nesting-like-a-motherf/349480/23 "2006-03-25T10:20:55Z")
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 ---
**Author:** ![Inigo\_Montoya](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/inigo_montoya/32/124_2.png) [@Inigo\_Montoya](https://boards.straightdope.com/u/Inigo_Montoya)\ **Post date:** [March 25, 2006, 12:32pm UTC](https://boards.straightdope.com/t/woo-i-am-nesting-like-a-motherf/349480/24 "2006-03-25T12:32:02Z")
Heh…loops are cool. ---
**Author:** ![MissMossie](https://avatars.discourse-cdn.com/v4/letter/m/f6c823/32.png) [@MissMossie](https://boards.straightdope.com/u/MissMossie)\ **Post date:** [March 25, 2006, 2:59pm UTC](https://boards.straightdope.com/t/woo-i-am-nesting-like-a-motherf/349480/25 "2006-03-25T14:59:14Z")
Am I the only one who prefers SAS? ---
**Author:** ![BelZarak](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@BelZarak](https://boards.straightdope.com/u/BelZarak)\ **Post date:** [March 25, 2006, 3:27pm UTC](https://boards.straightdope.com/t/woo-i-am-nesting-like-a-motherf/349480/26 "2006-03-25T15:27:57Z")
=IF(ISERROR(HLOOKUP(B$51,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE)),0,HLOOKUP(B$51,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE))+IF(ISERROR(HLOOKUP(B$52,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE)),0,HLOOKUP(B$52,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE))+IF(ISERROR(HLOOKUP(B$53,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE)),0,HLOOKUP(B$53,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE))+IF(ISERROR(HLOOKUP(B$54,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE)),0,HLOOKUP(B$54,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE))+IF(ISERROR(HLOOKUP(B$55,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE)),0,HLOOKUP(B$55,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE))+IF(ISERROR(HLOOKUP(B$56,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE)),0,HLOOKUP(B$56,forecast!$B$4:$AX$52,NCF!$A2_48+2,FALSE)) That’s a fairly standard formula that I use every day. It looks nasty, but it gets the job done. -Belz [Previous page](https://boards.straightdope.com/t/woo-i-am-nesting-like-a-motherf/349480.md?page=1)