Answered step by step
Verified Expert Solution
Link Copied!

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 ,

image text in transcribedCan 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 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Rules In Database Systems Third International Workshop Rids 97 Sk Vde Sweden June 26 28 1997 Proceedings Lncs 1312

Authors: Andreas Geppert ,Mikael Berndtsson

1997th Edition

3540635165, 978-3540635161

More Books

Students also viewed these Databases questions

Question

Is (log n)3- O(logn)? J ustily your

Answered: 1 week ago