2&#(-30,*-$2&#&#*2&!0# '**',%,"+,%#+#,211-!'2'-,2 9

If you’re ready to take your Excel skills up a notch, IF is a great

function to start with. The IF function has three parts:

 EH@B<:EM>LM#Q<>E>O:EN:M>LMA>K>LNEMLH?MABLM>LMMH

=>M>KFBG>PA>MA>KMA>K>LNEMBLMKN>HK?:EL>

 5A:MLAHNE=#Q<>E=HB?MA>EH@B<:EM>LMBLMKN>

 5A:MLAHNE=#Q<>E=HB?MA>EH@B<:EM>LMBL?:EL>

The Test

#Q<>E<:EELMA>?BKLMI:KMH?MA>'$?NG<MBHG:EH@B<:EM>LMZ*H@B<:E

PBEE>O:EN:M>MHMKN>

7HN:K>G]MCNLMEBFBM>=MHGNF;>KLBGRHNKM>LM2>QM;:L>=

M>LMLPHKD:LP>EE:G=MA>HGERMABG@RHNG>>=MHK>F>F;>K

BLMHINMMA>M>QMBGJNHM>L$HK>Q:FIE>B?:I:MB>GM]LIKBF:KR

BGLNK:G<>BLLMHK>=BG<>EE :G=RHNP:GMMHM>LMB?MA:M

O:EN>BLMedicareMA>M>LMPHNE=;>B10 = “Medicare”'G

MABL<:L>B?<>EE BLMedicareMA>M>LMPBEE;>MKN>'?<>EE

BLMedicare AdvantageMA>M>LMPBEE;>?:EL>;><:NL>

#Q<>EBLEHHDBG@?HK:G>Q:<MF:M<A

GHMA>KMABG@RHN<:G=HMHF:D>RHNKM>LMLFHK>IHP>K?NE

:;E>MHLBFIER<A><DB?MA>?BKLMMPH=B@BMLH?MA>!.2<H=>:K>

992A:MM>LMEHHDLEBD>MABLLEFT(H3,2) = ”99”,HMB<>MA:M

MA>99 BLBGJNHM>LLBG<>MA>*#$2?NG<MBHGK>MNKGLM>QMGHM

GNF;>KL.NMMBG@?NG<MBHGLBGLB=>H?HMA>K?NG<MBHGLMHF:D>

FHK><HFIE>Q?HKFNE:LBL<:EE>=ZG>LMBG@?NG<MBHGL[

True and False

-G<>#Q<>E>O:EN:M>LRHNKM>LMBMLG>QMLM>IBLMH=>M>KFBG>

PA:MMH=HB?MA>M>LMBLMKN>:G=PA:MMH=HB?MA>M>LMB??:EL>

7HN<:G>GM>K:GNF;>K:LMA>K>LNEMH?:M>LM$HK>Q:FIE>

BG:;HGNL<:E<NE:MBHGB?MA>>FIEHR>>F>>MLMA><KBM>KB:BG

G>>=MHINMZ#+[BGJNHM>LHK#Q<>EPBEENGLN<<>LL?NEERMKR

MH?BG=:G#Q<>E?NG<MBHG<:EE>=#+:G=RHNK?HKFNE:PBEE

K>LNEMBG:G>KKHK

7HN<:G>O>GINM:GHMA>K#Q<>E?NG<MBHGBGMA>MKN>HK?:EL>

L><MBHGLH?MA>'$?NG<MBHG$HK>Q:FIE>B?QBLMKN>MA>GLNF

HG>L>MH?GNF;>KL'?QBL?:EL>MA>GLNF:=B??>K>GML>MH?

GNF;>KL2ABLBL:GHMA>K>Q:FIE>H?G>LMBG@?NG<MBHGL

Putting it All Together

-G<>RHNA:O>=>LB@G>=RHNKM>LM:G==><B=>=PA:MMH=HB?

MA>M>LMBLMKN>:G=PA:MMH=HB?MA>M>LMBL?:EL>RHN:K>K>:=R

?NG<MBHG:K>L>I:K:M>=PBMA<HFF:L#GM>KMA>EH@B<:EM>LM

?HEEHP>=;R:<HFF:?HEEHP>=;RPA:MMH=HB?MA>M>LMBLMKN>

?HEEHP>=;R:<HFF:?HEEHP>=;RPA:MMH=HB?MA>M>LMBL?:EL>

IF

By Nate Moore, CPA, MBA, CMPE

SOFTWARE

$BGBLAMA>?NG<MBHGPBMA:KB@AMI:K>GMA>LBL

L>>:K>LNEMBGMABL?HKFNE:B?MA>:O>K:@>BLE>LLMA:G100

Nesting Functions

2A>'$LM:M>F>GM:EEHPLRHNMH<AHHL>;>MP>>GMPHK>LNEML

MKN>:G=?:EL>5A:MB?RHNG>>=:MABK=K>LNEMBGLM>:=H?CNLM

MKN>:G=?:EL>-G<>RHN]K>?:FBEB:KPBMA'$MKRG>LMBG@FNEMBIE>

'$?NG<MBHGLBGLB=>>:<AHMA>K$HK>Q:FIE>MH>O:EN:M>:M>:F

BGRHNK;BEEBG@=>I:KMF>GMRHNFB@AML:RMA:M?HKMABLM>:F

?BEBG@E>LLMA:G<E:BFLBL:;:==:R;>MP>>G:G=

<E:BFLBL:G:O>K:@>=:R:G=:GRMABG@HO>K<E:BFLBL:

@K>:M=:R7HN<:G]M@>MHG>'$?NG<MBHGMH<:E<NE:M>BadAverage

7HNFB@AM?BG=BMA>EI?NEMHP:M<AFR#Q<>E4B=>H:O:BE:;E>

?HK?K>>:MD>E:IKH<HFOB=>HLIAI-G<>RHN]K>?:FBEB:KPBMA

'$P:M<A#Q<>E4B=>HMHL>>FHK>>Q:FIE>LH?NLBG@

G>LM>=?NG<MBHGLPBMA'$LM:M>F>GML$BG:EERB?RHNA:O>:

LN@@>LMBHG?HK:?NMNK>Billing <HENFGL>G=RHNKB=>:LMH

A;F:D>E:IKH<HF

Conclusion

'?RHNIK:<MB<>NLBG@'$RHN]EE?BG=:GRGNF;>KH?:IIEB<:MBHGLBG

RHNK>O>KR=:RLIK>:=LA>>ML2A>FHK>RHNNL>'$MA>>:LB>KBM

PBEE;>MHK>F>F;>KMA>LRGM:Q:G=MA>LMKN<MNK>MH@>M'$MH

SOFTWARE

Sound

Off!