Question
You want to give a bonus to employees who have worked more than 3 years and have sales over $10,000. Which formula should you use?
You want to give a bonus to employees who have worked more than 3 years and have sales over $10,000. Which formula should you use? =IF(AND(A1 > 3, B1 > 10000), "Bonus", "No Bonus") =IF(A1 > 3 & B1 > 10000, "Bonus", "No Bonus") AND(IF(A1 > 3, IF(B1> 10000, "Bonus", "No Bonus"))) =IF(A1 > 3 AND B1 > 10000, "Bonus", "No Bonus")
Step by Step Solution
3.37 Rating (153 Votes )
There are 3 Steps involved in it
Step: 1
The correct formula to use is IFANDA1 3 B1 10000 Bonus No ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Fundamentals Of Organizational Behaviour
Authors: Nancy Langton, Stephen Robbins, Timothy Judge
5th Canadian Edition
013420493X, 978-0134204932
