Labels:bulletin board | dialog box | earth | sky | window OCR: Returns value condition you specify evaluates to TRUE anc another value if it evaluates FALSE Syntax IF[logical est value if _true value if false] Logical tes Aue value or expression that aq ueo evaluated to TRUE OFFALSE Value if true the value that is returned if Iogical test TRUE value if fal is the value that is returned if logical test is FALSE Examples SUDDOSe you UEY to assign letter grades to numbers referenced I by the aweu Avel age Score See the folloving table Aver rageScore is Then return Greater than From 80 to From 70 to From 60 tc than You can use the follow Bing nestec IF function: IF(Aver: age Score>89 "AIF[Aver: age Score> 79 "B" IFLAver aeScorex69 IFLAver ageScore>59 DF Svntax expressior Ietter following Scor
(.png)
