se the appropriate nested functions: If the employee's Age is 63 or 64 or 65...
80.2K
Verified Solution
Link Copied!
Question
Accounting
se the appropriate nested functions: If the employee's Age is 63 or 64 or 65 or66, and the Gender is Male, and the Rating is 1 or 3 or 5, multiply the Annual Units Sold by the price in cell N2, otherwise enter a 0 in the cell. (Use absolute cell referencing where necessary). Copy the function down to the other cells in the column.
In W10 use the appropriate function to calculate the total for all the employees. Format comma style 0 decimal
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
