BOBO X d H H H H H H $ H ` Z - j F LOM! ` x H H @Rg( H H ( d h Fv l / d = L L H / H / \ d F |8 a v DSET T h h D D M F i & l j ` D
F
G
i
k
&
'
l
t
j
v
.
2
]
`
Format for logical formulas:
=IF(C2="Their","Well Done","Try Again")
= indicates that a formula follows
IF prerequisite for a logical statement or test
(place test within parenthesis)
C2 cell reference that you are testing for a condition or answer when writing as an interactive spreadsheet
=what follows is the answer that you are looking for (correct answer)
Their in this case, the correct or expected answer is Their. When text is the expected answer, place in quotes, the comma separates your conditions
Well Done, this is the response you want placed in the cell if the student had the correct response.
Try Again this is the response that you want placed in the cell if the student had an incorrect response.
=IF(cell reference=desired student response,response when student response is correct, response when student response is incorrect)
Other examples of logical formulas:
=IF(C3="there","Good for You","Incorrect")
=IF(C5="their","Hooray!","Try Again")
=IF(AND(E3=2,E2=1,E5=4,E6=5),1,0)
=IF((F3=ROUND(A3,0)),1,0)
=IF(AND(C2="Correct",C3="correct",C4="correct",C5="correct",C6="correct",C7="correct",C8="correct",C9="correct",C10="correct",C11="correct"),"WOW","Try Again")
=If(B3=7,10,0)
=IF((B1>=93),"A",IF(AND(B1>=85,B1<=92),"B",IF(AND(B1>=77,B1<=84),"C",IF(AND(B1>=69,B1<=76),"D",IF(AND(B1>=0,B1<=68),"U","n/a")))))
Z N DSET 2 H , 6 * DSET 2 H @ d 4 6 * DSUM HDNI STYL ~ J STYL x =
3
2
R HASH
$ . .
.& L:Q h ja zo }Bod 4
CHAR "
@ HASH
R
CELL #
" HASH
GRPH ( HASH l
RULR ( HASH @
KSEN
" HASH , LKUP
0 $ NAME Default
Default SS
Default TB Header Body Footer Footnote Footnote Index D FNTM Helvetica Geneva
Comic Sans MS MCRO MCRO oBlN MARK MRKS MOBJWMBT SNAP ? : : H H
H H @ A kZkZso{o{wskZ^so{s{ws{wg9^so{swwo{ss C sVo{^o{Rso{Zo{skZZZg9g9Zo{ZkZco{Vc^^{ {w W"cg9kZg9skZg9^kZ{{o{wwcg9s^^{w{g9wo{^wo{{o{kZw _+wkZcg9o{ckZskZo{o{g9V^w{o{ZwV^c^Zg9V{o{kZg9{g9^^Nsco{o{ w w o{ { Mwo{{{g9{wo{{kZg9{kZ{Zww{ s{o{g9kZww{ O#wo{o{sZVkZg9kZcVZsZZkZVsVc^o{Vccso{VsVVcc k1wRB{www{wkZg9o{{{o{{{{kZ{g9{kZ{{wwg9{w{o{{{g9 k1wJR9g9RwJR^RVVNscVo{Vo{kZg9V{^o{VZVZ^JRRo{cVcNscRZ^o{s^g9cNsRo{ w w s E sg9o{{{o{{kZ kZkZw{{s{kZg9{wg9 I ZcVV^Vg9o{^ZVo{kZJRo{o{RkZVo{ZVcF1kZZg9cNsJRo{RV wg9 w o{ o{VZkZ{g9{{c{w{g9kZwo{{{w{o{{g9wZ{w{{w{g9{kZ{w{
w{{kZ{ IV^9skZZZ^o{w=sRVkZVVZVso{g9Vg9kZo{^Vg9cNsc^^VJRo{kZVRo{Nsg9sVkZcRkZNso{o{VRkZkZNs{g9RRVJRVR{^^RV^o{ s o{ M{kZ{{{{{{{kZ{ kZ {{w{o{{o{{o{ W'kZJRg9kZo{VkZRkZVVkZNso{kZ^o{VRg9RkZo{cZNswJRg9^JR^NsZVZJRVg9o{ o{ w wss{kZc{g9{{o{o{{+{{g9{kZ{{ws{s{{g9{ws{{w{s{{{{o{ Hwo{NsVkZF1o{kZNsVg9RVJRo{ckZo{kZRZkZRcRJRRNswZkZF1o{{kZNsNsR^JR{^V^Ns^kZJRcc^skZ^Rsg9=g9g9NscNsRVJR^o{ { kZ w w Ko{ZJRg9{so{{w o{ {{wg9kZg9o{w FZ=-k=5o{o{RcNso{Ro{cVRF1RkZF1cNsZcVZo{ckZRscRZNsNs^^g9^F1wVRJRZ^NsZsckZo{o{g9Nsg9^Z^cV^Z { s ;{{{w{w w { kZ { EZRJRcg9Zg9^kZNswNsJRZRZg9g9Bg9cVcNsVVNsZsscVRcNso{kZkZRg9Rg9V^JRRg9Ns{ZNscZJR^Vg9R^NsNsZ^Nsc^V # w{w w s s s{ާ 'o{^c^VwkZZRcVg9^cRV !w{w{w{{ޫ So{Ns^g9g9 kZo{o{{w o{{w w{wg9{w{w Eo{)JRZVZJR%)1)JckZ^kZZg9o{NsVcR{ZR^RZRg9NsR{cRo{kZNsZNsg9ckZRg9R^cRo{kZkZg9^Vco{^cVsg9wccVc r {w{{{w{ww{www{kZ{{wwsw{{ws{ ww{ w '{wwwwww { Mo{^c^JRZZg9g9c^RZcVRw^Z^Z o{^o{cVNscVZVVZֿ E{sww{ws{w{w{wswg9{{{w Zs^Rg9{kZ{{w{wo{{{w {{wkZ{ V9NsZs1!=-k-kccZ^w^cg9^cVo{kZRNscVZV'RcNs^{cRo{kZNsZNsg9ckZRg9R^cRo{kZkZg9^Vco{^cVsg9wccVc |{^{=w{w{swwg9{s{wo{ww{so{{{w{www{w{{w !{w{ww { O#o{^c^JRZZg9g9c^RZwZZo{cVcRZkZR^c^R^RZRg9NsR C{w {wsw{{wwwwg9{www CZ^kZo{o{ wc{{{{kZsw { Co{^NsNs^VkZcV^Vg9^Zg9ZZkZcZ^{V^cVkZ^cZwcg9^Vc^kZckZcg9V^VkZZZkZ{kZkZZV^g9^^Zg9o{RZg9ZkZ s{^{w{www{{ww{ww{{s{sww{wwkZwww{{swwkZw{ww{ +{{skZss {{{ Esg9ccNsc^kZg9g9cc^VZ^cZo{sVws^Z^ccsg9{g9g9cVVg9^^Zg9o{ZRg9Zo{kZkZVg9^Vg9Vg9^cVkZV^VcskZ^ {w {wwkZw{w{{wwww{{wwskZww{w{w{{wsw{
{wkZwwwww sc o{kZ^g9Z^kZZg9c{Z֧
{sww{ss{c /{kZ{{ {w{{s { S%o{{Vcg9ZZ{ZRg9ZVg9^ZcwZcZcZo{kZRZZc^Z^o{^V{ M{s{wsswg9{o{ssws^{so{s{wo{{o{o{ M
{kZkZso{kZwo{{{o{wss{wwso{wo{o{kZw e.wo{o{^o{kZg9g9{cV^^g9c{g9g9Zg9^kZccZsg9kZg9g9{ckZg9Zc^^csg9{o{ c-{o{{kZo{s{{wsssw{so{sww{ws{so{wwo{{o{o{{wss{s E kZo{wskZwo{{so{{{o{{so{w w{o{ U wkZo{^o{kZo{g9g9^Vcs{ZZ^g9Z^cg9{o{Zg9JRo{^ZkZo{kZ S%kZkZo{s{{wss{w{wss{o{kZ{{{o{g9co{{{o{ M{o{o{swso{{skZw{o{kZwwwkZwwswwso{ W'wo{o{^o{cVkZVo{o{^{cg9o{^wo{g9kZkZsc^g9ZkZo{^ccg9o{o{o{o{s Q{o{{kZ{so{so{kZskZwkZswwkZso{
kZso{{skZo{sskZ A {kZo{wwkZo{{sww{o{sws{{o{wwsw C wso{co{o{^wg9Z^so{kZRZo{kZo{RkZo{skZwo{so{o{ ?{o{{kZkZ{s{ws{ww{swkZwswso{co{s o{ g {kZo{w{wo{wso{{ o{{sswws{{{o{swws{{ wo{o{co{cVkZZkZcwwkZ^^cg9g9wckZg9g9wo{kZ^ckZg9kZcw g9ZkZso{kZ^g9^kZwg9{kZskZg9wkZg9g9cg9g9scwo{Zg9skZ HkZkZ{so{skZo{o{{{so{{ssw{o{sswsw{so{{so{{{ws{{o{w{{wo{swso{{{ss{o{wkZ{{ [{{wo{sww{so{wwo{w{{w{{swswwswww (sckZcZo{cw{kZ{swskZg9^g9g9cwcso{o{Vwso{kZcckZckZcswwo{cs g9^^g9kZs^{o{Zo{wskZkZccg9kZo{^so{o{o{swkZc 0{o{{g9swwkZwwo{o{w{o{s{{kZso{wsso{{{o{o{{skZ{wso{{wo{s{o{{o{swo{swss{o{so{kZ +
{s{w{{sww{wsg9s{ C
o{ckZ^kZc{kZ{wF1o{R^ssskZg9so{cc^kZo{so{ C{{kZswswswo{wws{{ws{RkZo{{o{ %{o{wwkZwwo{{{o{sw %wkZco{JRg9wkZo{o{so{c '{skZwkZco{wswwskZso{g9 I{so{w{o{{wsww{{wso{wwsws{wsw{w{s{s{swssw{wso{{{o{s{s{www ({{kZco{o{JRkZsso{kZco{{sVwsZo{^Zo{ZkZ^^o{ss^Zg9o{ckZkZsg9o{ wcc{o{kZso{R^ckZcg9g9o{o{wkZw{cg9co{c^^Zw
{skZwkZg9co{{o{wskZwo{o{wkZwo{wg9scg9swwo{kZo{sws{o{sg9{kZw{kZo{g9swkZg9o{o{ww{wwo{so{so{o{cw swwsswwwo{ww{{w({{o{wws{o{sww{wso{{{o{s{ww{{ww{sww{{ kZso{
RcZkZg9cco{ss^g9/kZ{kZco{wskZkZ{o{kZkZ{JR^ckZ^g9co{o{g9o{o{^o{kZscZ^o{{g9kZw{kZo{g9g9so{^o{o{ swg9o{kZwo{
co{o{wsg9{wkZo{sw,o{g9o{kZ{skZs{g9wwo{kZkZcso{wwg9o{kZo{wwkZkZo{kZ{wwwwkZ{kZccg9kZ TNAM ACCB5A41F528DC615A97294EB1C418CPRT /
com.apple.print.DocumentTicket.PMSpoolFormat
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.DocumentTicket.PMSpoolFormat
application/pdf
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMColorSyncSystemProfilePath
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMColorSyncSystemProfilePath
/System/Library/ColorSync/Profiles/Generic RGB Profile.icc
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMCopies
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMCopies
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMCopyCollate
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMCopyCollate
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMFirstPage
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMFirstPage
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMLastPage
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMLastPage
2147483647
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMPageRange
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMPageRange
1
2147483647
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PrintSettingsTicket
com.apple.print.PageFormat.PMHorizontalRes
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMHorizontalRes
72
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMOrientation
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMOrientation
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMScaling
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMScaling
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMVerticalRes
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMVerticalRes
72
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMVerticalScaling
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMVerticalScaling
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.subTicket.paper_info_ticket
com.apple.print.PageFormat.PMAdjustedPageRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPageRect
0.0
0.0
734
576
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMAdjustedPaperRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPaperRect
-18
-18
774
594
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMPaperName
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMPaperName
na-letter
com.apple.print.ticket.client
com.apple.print.pm.PostScript
com.apple.print.ticket.modDate
2000-07-28T22:57:04Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.PMUnadjustedPageRect
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPageRect
0.0
0.0
734
576
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMUnadjustedPaperRect
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPaperRect
-18
-18
774
594
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T14:54:57Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.ppd.PMPaperName
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.ppd.PMPaperName
Letter
com.apple.print.ticket.client
com.apple.print.pm.PostScript
com.apple.print.ticket.modDate
2000-07-28T22:57:04Z
com.apple.print.ticket.stateFlag
1
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PaperInfoTicket
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PageFormatTicket
ETBL hDSUM HDNI STYL MCRO ooBlN MARK WMBT SNAP TNAM ;CPRT ;+ETBL jDV