Cut&Paste Formulas

As promised, I have put together a "cheater page" for some of the longer and more complicated formulas. This is NOT all of the formulas from the book. It is only some of the longer ones or ones with special characters where a simple typo could cause you some serious aggravation.

The table below references the page number and figure number from the book, and the Excel Cell reference where the formula would be entered. Just triple-click on the formula and it should highlight. Then just copy it (CTRL+C), and paste it (CTRL+V) into your spreadsheet.

For OpenOffice users, see Calc Notes

 

Page Figure Cell

     Excel Formula

81 4C C4 =IF(ISBLANK(B3),B4*C5*C6*C7*C8*C9,B3*C5*C6*C7*C8*C9)
110 5G G7 =IF(ISBLANK(B6),G6,(F7*G$2)+(G6*(1-G$2)))
110 5G I7 =IF(ISBLANK(B6),G7+I6,E7+((1/E$2)*G7))
114 5H I7 =IF(ISBLANK(B6),(IF(ISBLANK(H7),I6+G6,(H7*I6)+I6)),E7+(1/E$2)*(IF(ISBLANK(H7),G7,H7*E7))
114 5H N7 =IF(ISBLANK(M7),J7*K7*L7,M7)
132 6A B4 =(B3-AVERAGE($B3:$H3))^2
132 6A H5 =SQRT(SUM(B4:H4)/(COUNT(B4:H4)-1)
137 6C J6 =SQRT(SUM(B5:J5)/(COUNT(B5:J5)-1))
144 6F C10 =IF(B10>0.5,NORMSINV(B10),0)
173 7D B7 =SQRT((2*B2*B5)/(B3*B4))
173 7D B10 =(B3*0.5*B9*B4)+(B2*B5/B9)
176 7G D9 =IF(ISBLANK(C9),"",IF(E9>B9,(C$5*0.5*E9*C9)+(C$4*C$6/E9)+(C$6*C9),(C$5*0.5*B9*C9)+(C$4*C$6/B9)+(C$6*C9)))
176 7G E9 =IF(ISBLANK(C9),"",(SQRT(2*C$6*C$4/(C$5*C9))))
176 7G F9 =IF(D9=D$16,(B9),"")
176 7G G9 =IF(ISBLANK(F9),"",IF(E9>F9,(E9),F9))
181 7K B15 =SQRT((2*B2*(SUM(B8:M8))/(B3*B4)))
181 7K B16 =COUNTIF(B10:M10,”>0”)