Discover millions of ebooks, audiobooks, and so much more with a free trial

Only $11.99/month after trial. Cancel anytime.

Excel 2013 Formulas
Excel 2013 Formulas
Excel 2013 Formulas
Ebook1,346 pages11 hours

Excel 2013 Formulas

Rating: 4.5 out of 5 stars

4.5/5

()

Read preview

About this ebook

Maximize the power of Excel 2013 formulas with this must-have Excel reference

John Walkenbach, known as "Mr. Spreadsheet," is a master at deciphering complex technical topics and Excel formulas are no exception. This fully updated book delivers more than 800 pages of Excel 2013 tips, tricks, and techniques for creating formulas that calculate, developing custom worksheet functions with VBA, debugging formulas, and much more.

  • Demonstrates how to use all the latest features in Excel 2013
  • Shows how to create financial formulas and tap into the power of array formulas
  • Serves as a guide to using various lookup formulas, working with conditional formatting, and developing custom functions
  • Shares proven solutions for handling typical (and not-so-typical) Excel formula challenges
  • Includes links to the "Mr. Spreadsheet" website, which contains all the templates and worksheets used in the book, plus access to John Walkenbach's award-winning Power Utility Pak.

From charts to PivotTables and everything in between, Excel 2013 Formulas is your formula for Excel success.

LanguageEnglish
PublisherWiley
Release dateMar 13, 2013
ISBN9781118490457
Excel 2013 Formulas

Read more from John Walkenbach

Related to Excel 2013 Formulas

Related ebooks

Enterprise Applications For You

View More

Related articles

Reviews for Excel 2013 Formulas

Rating: 4.5 out of 5 stars
4.5/5

2 ratings0 reviews

What did you think?

Tap to rate

Review must be at least 10 words

    Book preview

    Excel 2013 Formulas - John Walkenbach

    Idbook_preview_excerpt.html}[F_Ӹi{%mF,L$Ĉ(4o{"'KN旙UY ٍ ~~qkɳE&;y2-YYeyӦkr}{z  bQ⟼9[޻XY=[1U=u5-]\SY]Y=OS{6-p|Zκ yݬ򮣯fY^Ͳve]ݶݷ}:=1V#Uٖe͚w̷כ|8z9/N>ڣBizU.oY5#yiu^mK(ƛwMUVA~CN7 (Oʚb^4M1/e??a(NzYNx)afu{??~7*fw/nt-y]de[zcW_u٬R"_ehab3R?zklY\򛫜lM ?⟄rːa(ŊuS^tQfest6E(LK*hU^Vt!D~9~ױ-/rN-"'ƀ% zӴlWV5UVr-̃"<\ҕصG]1í5]b̰ͪh1ZSbg|)_2ߞo{C}S2a7ۆ._tOՄ0hc^G.!!uj_EEK3%+_rsU0}eUϫt6&' 9* 7\V虣 cW D¦kwΊ*oʢY.t`6yU R'>f2r4!pZ/7-})䵬Ŕw./r> de. zYDl,ofߎ<-1Y僟=Nk:Jݗ_քk6o<[BjZl8>Ť=zH~جV|_˼! 1 ZCq76 fVW@'>v8L"5gPՄKRxY[i0Ez^_jO,rYYoZ&dac̳eAJA7Ne'&r\u>>FM _:iO PhapmqXHҟl:лQn 6I_1Wn"d0"$1J~`+HhYof`e$ȇRG l "|`i!ȇO (K)f ˑq,S̺BJ,i$J%FrX50U`̊ȣd]fwlb/W5m~]:r2a&Ll9#>l u י' GsT;UmPm+2bJ]I,ՙcp׸4Rr[{Q2ևKRؗJ({I8GgIWta"ܒ;?ޠ$6{ILx_b]H:$6(B/9˜(Y3 dfCE5-(5Hz5!, E޵ae뵧.Zm5) fϪ͏LH$t6ZJ;z}Ԥ{ lUi $3a irEd~sD 01:=!Ovda[ Q $֖|+0^*W=dgb"sd A&{f7_7$r1װ+h99R+{y2 FzVηj`2rz $2ɽ~Y!&6-| ?Rn1{ENYݏJ>ޝ* V?ptΩٻ冕v8{W_ q,Li-tD>x7p>S谊zR=_vBsoa୲,Nlzﱽ!ο_2&B\aݰVU*?o߾\#K6mH蕒=Nt1-J5CSB4Ģ5H@:t1_Y,f@:Q6 3{G1ӇI[_S hp߶ɮ[O/fl.k? XE fkbSd!\C?l,esϱ̐dLWtQAL DX=![וx` oǺc9dk߼5ȈէW -6*Ƌ{~ѱA&IJrb+A%o/N`MO_˟hЬ^LowdCoݣ>._RG&ݍM'ìnC|Xxv:1I3MxYe+ȪLG=nyf`Dn/iyk<0w4\`9 409}~Te$$>Ntӆ"Ϟ$vUNSZJKm!Y# Ap?*3݈3-^<}{<2@o>UDvWQ`Y#wդ]@6)/{OXkm'UvUE,*0s|g eEؐ-$_#10aS-''}h|°ILөߌ H㟺aBh֨LD˳Gٗԡ5O˘(gC!3J u U$y|G{%!ɡG``Rq)G)6UMrו:o3Vb NNd$C̹ 5#BRϛ8g_4YyY]\g:Rb 6u9c*MF&{Y7tъjrG3/*⿄ct- LY- Wȗ31!]zs>(tĹ܄A'qb?pMtS.g=x%p$TwC-჎X7>BtTQN?H33z\h1r .˭}A e)اd~ٔ3B ~UËiUPTֲYG$ %*L'}3RwUE} {$RgY _Q;Lɯ+€dٰ,sPU(jhV\{3eWDmRLs pRA&ՙCOs.I U1[xu2L@JXd\/f<`[se]Ud/`L)I_e.1U<АosI@WD%}%^p+ʃ CdGYAK(yL/',ᙴ)ML@Ɂ$vpM ވWO q@F3  we)\W!LvAm.#qȝW{\ Q1*-])`QB_{{]@-ٷf`p}a(!/`EsʛakFo,h'v(jOP'K[lm*N,Zs2Zb&dG,aH"rkt Y/kgXHK!N6ei ڀwБ$X;pU6oHLH ?e`%Fn8c "ӍB7+jf[Ld$NJ\ostӰ>_6dC[ Hg$c x.IO~?_5m:ܟ{ƹH7[kUV)"ҁ>|HeLj~#d@lU3k h +3Og{\m/pVL8>y%gA f) Q|vT3W 1ԶnxaE9AR~U0:a[vYK ^CA~ 8T=|3½>aم [Qg(̩6؅u Qi:L]{cK!r#;rZC 2~?cq#}]P?lr~ LgV嗂-BZ LoM!mf|R56X✈z?qxKfy 턴)Fn9Ӛ 3슃fꑔV>;:f5įCR.vyf,z D}>gȒ3L=H/%cvIU)Wd0 AwJkZ;88ΑdN(SFTY-%N\1)(b" U@ƒC:~ '/I DROs 8-[*A Aa0ڌ"Zh xbrle_2 [%G 6vQl%NW=Dz{LnY1=Xoחd`ט.8{ib>?8ͨ.UamAJ 2pb~"ωV#P~c$9쫺 җۄ.PKd&]ax]Iw"zȾ'n0ͮ-#gg@M(~#XG|p&Ռ94CvdLuè9>9ʹIncx]HҾۏ^336-FQ?W`ǶP"IޚEJ=Z !#ac2*? J-eO/%GٻFKHit?7ycUIiN/l K)F0{o!%(-Lè`۠tw& 6J]N_SV).'Y0*u#QxF3I eI$P~SVZW!qfVѓ&\ H0Uѽt|>/Ǟb[AUf;7qre(v)MBoXPAiJ SZ[c]"bw9m cGsސwsI)r3._Sξgj˚,dI3%m>Ƃ:5 eޣ_d+W3\y?s,8v"wh9ewDbwFr ̦#X:1Hu1b'ֽ#U%T8-zV6$@{@Y߬ w̌$[QgSN_9“ ÒTh+rzk!qy'N}6쳲!/)s(%Vxi qK[h$+%1 a؃EC-6 Y]HlzنAM;Z=91QrW2 ,$;ZAc|߈j(R9N27UF'ZN;٘[7v!&Ŝ=mx_M g %o"jY>A) %)8GS?$[8C%tqM@kOVph,VyDݡ=?#f̙=_ D39No19N}'A}VpDsTfEpidx@?XoŚsYp,]^kE@d;iK2Ay Yt؃34/*9Q*2;bS4jg+/Z"_Gr┶f.<.xcsq:!&$d/&+eOL|9j4-JihYemnJ&NnqQDUK8@Ibka-Eֵ,iqxH"K68woDP`ZOzeW<}lѠ*sOyrc\) ':^K,,,Vv$ojw ʉ[x-<&e7n;'U/-\xLۆw$Y/.kRRĢ##.L-f9M=DyFm==sF)CΤϫGg; $0L/oHwR{ǣm3xJpDjL/|h2 aAJ,! 4!h |há)@($&-IM.jo`ģ{-+_]&2"FK[ %"`1cS=p/.LY DHVd^N֒Ufb(˕K7`Dz'Ƭ1b}ER-0M^SCNb8}} 4gY=VDM.J)Rҝ u\y% ;5yP(ijs"1ݔ7ǟESQ e13&31^Ɛ  I0 F˞,$Q+WђK+ Y$ڨSCr/hDNHqN6;,+񋣇&YJֱj˥h@ tBt( \E ] v{ ːYvsU͵uɭV`vZ%eI컟J/>+Wl:fgwyt"iw!y!hH1ӡQȉHtH<p]th&4x{^)h&b(<489l!,Bn?kK?+KW<]Ǽ-Iʴ޸p; N9->síbhx W' )\6#EΔn k$U{Lb I%7C!#|(HJڂ#J\jfSsAN $DL'UYպֹQ9fZ(+w)4/jوPBW:`RvYk-§Y-?̹! 4uSy%z0Pf ֒O;oծ5ax.[ ]O@F+* .r%5LVBϿ6~Q7tQ,($(;PpC!5>@vOTab`GzRk RZH JQrCK>cd\ō[?{Ο<'ZgcSE`iak\}',HXEVsbV+dq8V\/#eg8!Ns]tw+^X2|%Y@vɚhҶk!0g3zFL8]IGo2[MBC=eeĈz_-qœ.yCXi4Gdģ7cu B"6Mn`$1â#fZDHs zxi 736d<~V?A1k("n$|mc5ʐ~i0Z۹W3sŻcmq5$z6R+ʜM6: dkէPوNqu2J;nZ|D_V.d㔪$5 xuކ2iNpį}50yPV7 +y,!-|kuѴAڿ4Q QMD_VThe."Ia  xוx Ma羵ʹH .P'xwkERkS=$uW(cH_uz, :B7be4ec Mf[O{\$CY…Cto5'&R~59q/Ks n`!n*NBW^kiH|`iX6fwLb'3 #F^u6klD:`tZ'P|m[xXn WP (äaY~Y\͕0>HpւIb_ҐPJJub #^x zQ;ǙT+Fڰ8\s۬ 3{Zꀾn圪d?7#+f|f%&4ϨJDh'_NAm%%\7q/_RzhsG%l]\- |kASs&:gG'N?J=ۆwSrE{jo#hQ^4XdHUf=m{HU){BJ$u"0N灄WH))OE>CGIkO+jU+M א8j za(eߖm.V+c-[`XHl4f09~`1J(0NHi޺3=L}h,% qf`^H,4e &-Mɼ[j^dKOSJ#:SȽ>w/׆f9꽓@spTI3H~ڃk 1~sb~PKnO!6a [YnD 5lVť3rW,0 h7 @O`{J\NSh&t U,{C2%u+Tje'!/)sIelmJ.0rUa|4. ۳+)_? 1z.E4ʙu6}I]k5kEdUL L7&>fYd>Od6 e(z"KA,me䮤s#X,]nVn*~psb)IŀX@dGupVJXlZ y#hoa?KI"~%ו*1xskz}:؜_>!\M(EmOۺX#%%+G)? .)>0['Cmc zQ4& u;+L~K7}njuO5:5NqvhֿZDs@'=Qk!$dB׊m8tլӼF\3K6?&ͤGEMlh[_4lȃLz<"*k_[%+~4cihE 8:xZSN\ODCq [%qzƝsg"?{[(|eiFLT!`5Y#1--<Ű>G?;5@, [ĩG ۼiM G fVҠ ֵEϫ_,'3h1yߚW'ː-Y8ZH1!9 Y YFEcRMm.RD Dzc7 &{rv3e]Su&q$P902ٰτuWZdBzL;oӹ6DX?֝o/)xȷowf17[I:dag{ًSKM0^ȑ>a/c@>,~}2e0()kDP7J L2IKS/r'}DV!t̕?JfӮdRsà* ջ:8Lr;ɶzja c`P|J[p=tÍN0;qu D p۠Wxh3J_(xr[KU8Ws-)4`P7r?oɷm㣡|Pav?Rw窏n᪏]l!x 鸅rtB:%r-*ý=NN)n\2r_*y DYEְh3R'Q͎idA55QQ<`u2^+HʫXߖg+^Gyk48`ލQcpBvwΌzU Ҁz/qvUz: :2BEՙhN 썌>*'F mowC\!'y]֙f3Q E5EA̞!«j *R\HRK{t3H~𛭎O؉.hΘ$s^6T5&M0)M*+=/gv;GQXż~jEҺ<(MXM)/A|$s~f(^^Sfm})7qqjxǾz^<%!$5ޠ4- JONi@T*}t!HK򦸉ω{o۲U#FBl-DL@O˚= uI'WȌi  k>? ;@Dܻ3aJ\P-htkB moܑٜtʫi3e&%|A] 8j\4C`xs46]ͧ95nʞ6d#"Z1A9˿¨mRnaOö鐊[fBfŦEf|„Mr}h=S|$`EM vƃ,U鈴6gĕ{{+WimHw!)i.w1H6s~.< #mR%UCƾz :Rthŭِze)Y%j]IJ48Q5V䴉tK{:HNz𽺞cPߞw<&sR"gb)/);lCCvBa֯aTș&r0,S&eYbo|{GNZ_y݅L:PGU!~KzqCX$L?BcgA$烯I'"j%QԭT! -tx}YN>T|Ekp:(0Cw0"Kd Jn8or|`Bm601qw,X05cP蛭-1ʏmՎYqo ̓8~f!Z-HktCvfdEHh<2a6ePxqc Ĕgk.a:.Bp Op4H.!볐M@Q y~eD/JѱrpqH35fM8jXG3cZ@\]Dx 9Z!FԘbnj1Em;gi( ޟ62B Ǻz.9rv)̦ T{g q_ )& g7eSxs!v!,vIsפ 4E5mkUK}&|ч[i~2t^dn'qn?(S31{{BbxI[5^ ڮKCBr#D3JBeo1ik ƳPү%Ez],bQk1`qޔ6Ep(Zx7M=ZWQ7dw8I4kI( YC&,Tcoꢻ@|MmjȲ.ti4&Ƿif+lOP /1V*E$) - AW dx) %wW<2706ct:q cxQf|| NAiYP'>0kP_DJ[.U~ॳ/˫LGmK :neNR=dY}-Զ@׌}`<찒#+iFw-𻵐X?5)~ ZW:I?t|UJzQ8ãܩJ'qM[0Owr]HҹR1aֲ:Tҭ6,2 bhP"挪5F Bv&KPs+<仸A)yr#i`§ XFnj|9yb-EU=J!l^ٱ?%<>?=> O@3@C+k+ȿ@0W~j@ڀvE &=KݽA>( U4lledSrYcw(Cp@m=X ϔ 8K>@1.)bfY.9aۏ#áz!/I۞?kUV-u2?w"i˂uePjդzŶܶ-w@vr6ν0{+eH_>b gw[H H@~HX]ꚼ=:Q|6!,˶+l"!J!\) VR E(u<:V¥͊O?|s~Җ'Q6V|r/&M\QSyrjH>Tw2z48B)S)ni{7뵏MbvYk;T~ch]@'iH 6y7$8H<+3Myv/N-a iҪᔗΝG)7Ɠ)К\;eI"{3%hq Jz yJjgu̬pI:g*cC)*&Ŷ-{įo &RHG0.} tavfB?Eάu/v`Yb9|V~`ܩh:ͣ25\U}Jdy%0BBCs"*yTg@^>=< Fm;V]v-c1!'S&MW TΛYo0ЬԤ"f {-5ϧǧi/C|t0 ^:c mB6VLH78۹PJ1Q3ocXY ei١&ud9iosq`z~~z>XxZy=PW;^[rS )8:7M$ᨠͣY?S]u}Rj-Rxb+;:&Y,`~~<ѯPA,;ԏKFΕs[MCrMKzq:;_y '13F BD.D+egqgh7.B|i~%U2[ ;+^ijfOI`)ppr'GG"Ndw$m4I$ XVnÊ3GvGz&o)}xt^R"L\^=U6`Ool?35:gԥ=3 9v00^a|;cཇg'yy ,ӄg^&Aal=?&XVs(3튽Gru rWOl$ zH8otѩP/[xXHcF՛[dstp k3:N 1^uS=$NIV1&.'jV)x+^{OOG`N}mSV_J-Z?۝_mq\C[ʝee9w,}`=8E1tz`l%jTpsYIH]֣Wqrܝ vh(L{|8Av̀h_N~vWgw}Ns8Hc^ =A~ vv#w,;x˶z{ϗyCZݽ@vs/ j&*Bw Yfpy(n}Ýw1wVnPZers^c|pدk> ;ɇU[-nC4jڑFZ #k߾?8?~ 5,y͑;>&O# ny m朅:Jhˌ?%䓔&OPo_a2m=( ǡ?)I~WDԾȿgKxn>}O)ec]ˎ -POaUtU Xv@[YuF~4-8Y'^ڐ1'hg*ȊrOxʣY =h$nX{gb%SCR?X_@NLGXFXqIjXj#q޶瓏{_ĬZoc2q*[-r-5u{s+IV Ȥ9t\&K᧊ZJ$-K& 1 swBNDfMEޯ 7mu! GmVYn08> RhD54)1NK $,m9_Sv=ow8h?Kh<Y!ѥS_SX%N#tXAA?p.2ܠf"v΅J ?S8Cb~}0We"xx7fR%2zk%p~ƹ)Jx2tTW4WW\5&׳7 m\s̆g0[n GJy2KPOj`6\R&h$)9N!;$ULMPn%}R/vNGϹa? $ mk6 !V6޹ ?c_6ƭݞT?a9_,* '9ީ%w-vU83+  7MMQ(zu;{J9xz7OϾ~v{gF>2 L9b!_(_POlnF:X(7P j_4 *.iA Kt[e4~ƙ6öbPfnuh*n}פ'qI%dSi};l@kVOOHt|n"k=Fe 48Ň)q̈qD CI9
    Enjoying the preview?
    Page 1 of 1