Question

necessary 5. Lael is always on the lookout for students who might be interested in running for office in student groups In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future: If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text. b. Otherwise, the formula should determine if the value in the Finance Certified column is equal to the text "Yes" and return the text Yes if true And No if false.

Answer 1

I have applied the formula in excel in sample data. Please find below the screenshot of the same -

Book2 - Excel BS File Home Insert Page Layout Formulas Data Review View Σ ? A la le Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Function Used Time - Reference - Trig. Functions Function Library - Trace Pre fx Help Tell me what you want to do Define Name Fax Use in Formula Name Manager Create from Selection Defined Names Trace De Remove A1 Finance Certified Column B A 1 Finance Certified Column 2 Yes 3 Yes 4 Elected Yes No Formula =IF(B2="Yes","Elected",IF(A2="Yes","Yes","No")) |=IF(B3="Yes","Elected",IF(A3="Yes","Yes","No"))

Belwo is the associated result -

B5 <I File fx Home Insert Page Layout Formulas Data Rev Σ ? A AutoSum Recently Financial Logical Text Date & Lookup & M Used Time Reference Function Library Insert Function A1 Finance Certified Column с A B 1 Finance Certified Column Elected Formula 2 Yes Yes Elected 3 Yes No Yes 4

*****PLEASE DON'T FORGET TO GIVE THUMBS UP . I REALLY NEED IT