ZuoTi.Pro
Question

Using the IF Function, format the workbook so each student’s grade shows a pass or fail—P for pass, F for fail-based on the total points.

Can you tell me what to input in the Logical fields. I keep getting it wrong. Please see chart below.

Professor Williams Course | Exam 2 100 -Quiz 1 ▼ | Quiz 2 | Quiz 3 -Project 1 38.5 | Project 3 | Project 4-| Total Points Earned Final Grade T | Pass/Fail Student name Acosta, Angelica Alnusf, Ali AlSabt, Sadon A KH A Anderson, Chester Ballantine, David Behbehani, Mohammad Beier, Susanna Blackett, Christopher Cabander, Frida Cooper, Alexander Corson, Ba Cunnin Exam 1 Project 2 37.345 37.83 48.015 47.53 44.62 45.105 3.88 1.94 40.255 1.225 35.89 34.92 35.89 36.375 43.165 37.83 31.525 66.22 67.08 85.14 84.28 79.12 79.98 6.88 3.44 71.38 610.065 B 93.12 72.75 84.39 93.12 43.65 75.66 64.02 95.06 74.69 85.36 44.62 75.66 96.03 73.72 75.66 54.32 571.53 B- 597.405 B 43.5 37.5 43.5 9.5 49 46 46.5 98 637.7 A 566.36 B 492.735 C 314.42 F 321.4 F 593.695 B 564.015 B- 496.89 C 435.46 F 551.69 C 571.905 B 57.925 C 498.57 C 387.745 F 22.5 22.5 49 98 98 38.5 46 63.64 61.92 63.64 64.5 76.54 67.08 55.9 Brett Andrew 49.5 Friend, Jason Grzanowski, Michael 49.5 38 37.5 44.5 38 Alexander Brian 21.5 32.5

Function Arguments IF I A logical Logical_test Value if true Value_if false = any = any Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE Logical test is any value or expression that can be evaluated to TRUE or FALSE Formula result

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

IF function in Excel:

IF formula can be use to shows the result (i.e. Pass or Fail), either based on points or based on grades.

I've created above sheet in excel and apply the IF formula i.r.t. Grade i.e. If grade=F, result= Fail and if Grade is not equals to F then Result= Pass

Please refer file attached below for your kind reference:

- File Home InsertPage LayoutFormulas DataReview View DeveloperNitro Pro8 Cut Copy Σ AutoSum Fll Z в 1 u .田.焏,스, 田·ク·A· 掴Merge & Center. % , aiog Conditional Format Cell % ,-28鼎Conditional Format- Cell Insert Delete Format Insert Delete Format Sort & Find & Blu. ! ) Merge & Center. すForm at Painter Format Painter 2 ClearF Select Editing Formatting as Table* Styles Font Number P22 Student Nam am ฐ am Quiz uLL ui oject roject rojec Project otal points Earned al Grade Pass/Fail Acosta, Angelica Alnsuf, Ali 100 Anderson, Chest Ballantine, David Behbehani, Moh Beier, Susanna Blackett, Christo Cabander. Frida Cooper, Alexand Corson, Bail Cunningham, Bre Elenbaas, Andre Friend, Jason Pass 314.42 4635.8985.3663.64 71.905 B Harkavy, Alexar Hartman, Brian 198. 21.5 , HI sheet Is Sheet2 Sheet3,ウ Q. Pa-Pa-Pa Pa Pa Pa Fa-Fa Pa Pa Pa Fa Pa Pa Pa Pa Fa | 14 적의 98 88 44 의식에의의의의에 45 53 15 53 62-05 88-94 55-25 89 92 89-75 65 83 -96 75 87 96 45 78-66 98 77 88 46 79 99 76 76 56 43 3.5 39 3.5 4-22, 3-3-4-28, 50-48-2.5-3.5-AG 2.5-33 49-55 44-23 39 3.5 36 39 28 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 R

Formula View:

Home Insert Page Layout﹁ Formulas Data Review View Developer Nitro Pro Trace Precents Show Formulas Trace Dependents Eror Checking emove ArrowsEvlate Formula Define Name Calculate Now Use in Formula Create from Sel CoptuSheet Insert Autosum Recently Financial Logical Text Date & Lookup & Math More .. Remove Arrows - QEvoluste Formuls Windo Time* Reference & Trig ▼ Functions-Manager Window | Options Function Library Defined Names Formula Auditing ExarExam QuizQuiQuiz 3 Pr Projec Proje Project 4 Total Points EarnedFinal Grade Pass/Fail 100 77 Student Name 5048 38.5 96 IF([@[Final Grade]-F,Fail,Pass) IFFinal Gradell-F, Fail,Pass) IF@[Final Grade, Fail,Pass) IF(Final Grade]lFFail, Pass IF(l@Final Gradell F , Fail,Pass) IF@[Final Gradell-F, Fail,Pass) IF([@Final Grade]l-F, Fail, Pass) :Fİ @lFinal Gradell-F,Fail..,Pass..) IF@[Fina Grad-F, Fail, Pass) IF@Final Grade]]-F Fail Pass) EIFl@Final Gradel]-F Fail: Pass) IF@Final Gradell-F, Fail,Pass) IF([@[Final Grade]]- F,Fail, Pass) IFT@ Final Gradell-F Fall Pass IF(l@[Final Grade]ドF,Fail,Pass) -IFI@[Final Gradell-F, Fail, Pass) IF([@Final Grade]]-Fi,Fail,Pass) 4 Acosta, Angelica =SUM(C4:K4) -SUM(C5:KS) -SUMÍC6:K61 =SUM(C7:K7) 83 93.12 6708 -SUM(CS KS 75 37.83 6 AlSabt, Sadon A KH A 75 99 37.5 43.5 49.5 87 48.015 72.75 85.14 87 9843.5 489 96 47.53 84.9 84.28 66 3.88 75.66 6.88 98 1.94 64.02 3.44 77 40.255 95.0671.38 SUM (C9:KY) -SUM C10:K10) SUM(C11:K11) ; s.NA[Cru2ボ1% Beier, Susanna Blackett, Christopher 11 66 433 49 az 4汕maks, îi山 Cabander, Frida 併; KI 創 澼:iSLS.// 38.5 41.5 肌22i.nrx: n.m -SUM(C12:K12) -SUM(C13:K13) SUMIC14:K14) -SUM(C15:K15) -SUM(C16:K16) SUM(C17:K17) 14 Corson, Bailey 46 35.89 85.3663.64 78 34.92 44.62 61.92 99 35.89 75.66 63.64 76 36.375 96.0364.5 78 43.165 73.72 76.54 56 37.8375.66 67.08 43 31.525 54.32 55.9 49.5 37 17 Friend, Jason 18 Grzanowski, Michael 76 89 49.5 38 37.5 39 44.5 UM(C18:K18) SUM(C19:K19) -SUM(C20:K20 56 652821.5 32.54 4 SheetiSheet2Sheet3

"If you have any Query, then please put it in the comment box."

0 0
Add a comment
Know the answer?
Add Answer to:
Using the IF Function, format the workbook so each student’s grade shows a pass or fail—P...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT