Question
Assign point to each cell following the rule below: If Sale in a given cell is less than 200 then give 1 point. If Sale
Assign point to each cell following the rule below:
If Sale in a given cell is less than 200 then give 1 point.
If Sale in a given cell is more than or equal to 200 and less than 300 then give 2 point.
If Sale in a given cell is more than or equal to 300 and less than 400 then give 3 point.
If Sale in a given cell is more than or equal to 400 and less than 500 then give 4 point.
If Sale in a given cell is more than or equal to 500 then give 5 point.
DONT apply this rule to column Product ID!
What is the total point for the whole table?
Can you explain how to do this function in excel?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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
Banking Reforms And Monetary Policy In The Peoples Republic Of China
Authors: Yong Guo
1st Edition
1403900787,1403914540
