Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you show how to do these questions in excel? NESTED IF TUTORIAL 1. Question: 3. Question: If cell A1 is less than 20 ,
Can you show how to do these questions in excel?
NESTED IF TUTORIAL 1. Question: 3. Question: If cell A1 is less than 20 , then multiply it by 1,2 If Cl=0,H is equal to A1/2 If it is greater than or equal to 20 but less than 50 , then multiply by 2 If C1=1,H1 is equal to A1/2 times 20% If it is greater than or equal to 50 and less than 100 , then multiply by 3 If D1=1,H1 is equal to A1/25 And if it is great or equal to than 100 , then multiply by 4 4. Question: 2. Question: If D10 but 600, then IF A1+B14 but 9 but =14, the value is 50 If B1's value is 1 to 5 , then mutiply E1 by 0,77 IF A1+B1>15, the value is 75 If B1's value is 6 to 10 , then mutiply E1 by 0,735 If B1's value is 11 to 19 , then multiply E1 by 0,7 If B1's value is 20 to 29 , then multiply E1 by 0,675 If B1's value is 30 to 39 , then multiply E1 by 0,65, otherwise by 1Step 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