Funds And Pledges- Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VMEW

Question

Funds And Pledges- Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VMEW Conditional Formatting . Format as Table . insert Delete @cell Styles. Paste Sort , ormat Cells Clipboard Font Alignment Number Editi A. 2 Fund CodE 3 23 4 23 5 23 6 05 7 05 8 05 9 03 10 03 11 15 12 15 13 15 14 15 Fund Name Last NamE First NamTotal Pledged Books Books Books Children's Furniture Children's Furniture Children's Furniture Computers Computers DVDs DVDs Bartkus Karen David Kim Kim Emil Ted 150.00 100.00 1,000.00 Katz Lai Chiauzzi Bartkus Thompson andra Fraser Bartkus Foster Bartkus Nicodemus Paul Chang Burns Drimusz Alexander 1,000.00 100.00 200.00 150.00 25.00 1,000.00 50.00 150.00 1,000.00 150.00 500.00 25.00 250.00 Question 5 of 10 Allan Karen Adrienne Karen 16 09 17 09 18 09 DVDs e-Book Materials Front Desk Support Front Desk Support Front Desk Support Christina Tracy Laszlo Roxanne Show Task List Task: EX4052 Time Remaining: No Limit A Norton

Explanation / Answer

Formula to be used in excel

=IF((AND(A3=23,E3>100)),"TRUE", "FALSE")

And can be shifted down using: Shift + down arrow : to select

then pressing ctrl + D , to automatically fill it

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.