The given code: 'checking intX is less than 10 If intX < 10 Then 'Set intY equal to 0 intY = 0 'checking intX is less than 20 Elseif intX < 20 Then 'set intY equal to 1 intY = 1 'checking intX is less than 30 Elseif intX < 30 Then 'set intY equal to 2 intY = 2 'checking intX is less than 40 Elseif intX < 40 Then 'set intY eual to 3 intY 3 'if the conditions are not true Else 'set intY equal to -1 intY = - 1 'end of if condition End If Assume “intX” is 5 If intX < 10 Then 'checks 5<10...

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter 4.4, Problem 4.7CP

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'checking intX is less than 20

Elseif intX < 20 Then

    'set intY equal to 1

    intY = 1

'checking intX is less than 30

Elseif intX < 30 Then

    'set intY equal to 2

    intY = 2

'checking intX is less than 40

Elseif intX < 40 Then

    'set intY eual to 3

    intY 3

'if the conditions are not true

Else

    'set intY equal to -1

    intY = -1

'end of if condition

End If

Assume “intX” is 5

If intX < 10 Then 'checks 5<10...

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'end of if condition

End If

'checking intX is less than 20

If intX < 20 Then

    'set intY equal to 1

    intY = 1

'end of if condition

End If

'checking intX is less than 30

If intX < 30 Then

    'set intY equal to 2

    intY = 2

'end of if condition

End If

'checking intX is less than 40

If intX < 40 Then

    'set intY eual to 3

    intY 3

'end of if condition

End If

Assume “intX” is 5.

If intX < 10 Then 'checks 5<10...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Can I get help with this case please, thank you

I need help to solve the following, thank you

reminder it an exercice not a grading work GETTING STARTED Open the file SC_EX19_EOM2-1_FirstLastNamexlsx, available for download from the SAM website. Save the file as SC_EX19_EOM2-1_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file SC_EX19_EOM2-1_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. Brad Kauffman is the senior director of projects for Rivera Engineering in Miami, Florida. The company performs engineering projects for public utilities and energy companies. Brad has started to create an Excel workbook to track estimated and actual hours and billing amounts for each project. He asks you to format the workbook to make the…

Answer 2

Expert Solution & Answer

Chapter 4.4, Problem 4.7CP

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'checking intX is less than 20

Elseif intX < 20 Then

    'set intY equal to 1

    intY = 1

'checking intX is less than 30

Elseif intX < 30 Then

    'set intY equal to 2

    intY = 2

'checking intX is less than 40

Elseif intX < 40 Then

    'set intY eual to 3

    intY 3

'if the conditions are not true

Else

    'set intY equal to -1

    intY = -1

'end of if condition

End If

Assume “intX” is 5

If intX < 10 Then 'checks 5<10...

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'end of if condition

End If

'checking intX is less than 20

If intX < 20 Then

    'set intY equal to 1

    intY = 1

'end of if condition

End If

'checking intX is less than 30

If intX < 30 Then

    'set intY equal to 2

    intY = 2

'end of if condition

End If

'checking intX is less than 40

If intX < 40 Then

    'set intY eual to 3

    intY 3

'end of if condition

End If

Assume “intX” is 5.

If intX < 10 Then 'checks 5<10...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter 4.4, Problem 4.7CP

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'checking intX is less than 20

Elseif intX < 20 Then

    'set intY equal to 1

    intY = 1

'checking intX is less than 30

Elseif intX < 30 Then

    'set intY equal to 2

    intY = 2

'checking intX is less than 40

Elseif intX < 40 Then

    'set intY eual to 3

    intY 3

'if the conditions are not true

Else

    'set intY equal to -1

    intY = -1

'end of if condition

End If

Assume “intX” is 5

If intX < 10 Then 'checks 5<10...

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'end of if condition

End If

'checking intX is less than 20

If intX < 20 Then

    'set intY equal to 1

    intY = 1

'end of if condition

End If

'checking intX is less than 30

If intX < 30 Then

    'set intY equal to 2

    intY = 2

'end of if condition

End If

'checking intX is less than 40

If intX < 40 Then

    'set intY eual to 3

    intY 3

'end of if condition

End If

Assume “intX” is 5.

If intX < 10 Then 'checks 5<10...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter 4.4, Problem 4.7CP

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'checking intX is less than 20

Elseif intX < 20 Then

    'set intY equal to 1

    intY = 1

'checking intX is less than 30

Elseif intX < 30 Then

    'set intY equal to 2

    intY = 2

'checking intX is less than 40

Elseif intX < 40 Then

    'set intY eual to 3

    intY 3

'if the conditions are not true

Else

    'set intY equal to -1

    intY = -1

'end of if condition

End If

Assume “intX” is 5

If intX < 10 Then 'checks 5<10...

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'end of if condition

End If

'checking intX is less than 20

If intX < 20 Then

    'set intY equal to 1

    intY = 1

'end of if condition

End If

'checking intX is less than 30

If intX < 30 Then

    'set intY equal to 2

    intY = 2

'end of if condition

End If

'checking intX is less than 40

If intX < 40 Then

    'set intY eual to 3

    intY 3

'end of if condition

End If

Assume “intX” is 5.

If intX < 10 Then 'checks 5<10...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter 4.4, Problem 4.7CP

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'checking intX is less than 20

Elseif intX < 20 Then

    'set intY equal to 1

    intY = 1

'checking intX is less than 30

Elseif intX < 30 Then

    'set intY equal to 2

    intY = 2

'checking intX is less than 40

Elseif intX < 40 Then

    'set intY eual to 3

    intY 3

'if the conditions are not true

Else

    'set intY equal to -1

    intY = -1

'end of if condition

End If

Assume “intX” is 5

If intX < 10 Then 'checks 5<10...

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'end of if condition

End If

'checking intX is less than 20

If intX < 20 Then

    'set intY equal to 1

    intY = 1

'end of if condition

End If

'checking intX is less than 30

If intX < 30 Then

    'set intY equal to 2

    intY = 2

'end of if condition

End If

'checking intX is less than 40

If intX < 40 Then

    'set intY eual to 3

    intY 3

'end of if condition

End If

Assume “intX” is 5.

If intX < 10 Then 'checks 5<10...

Answer 8

Chapter 4.4, Problem 4.7CP

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'checking intX is less than 20

Elseif intX < 20 Then

    'set intY equal to 1

    intY = 1

'checking intX is less than 30

Elseif intX < 30 Then

    'set intY equal to 2

    intY = 2

'checking intX is less than 40

Elseif intX < 40 Then

    'set intY eual to 3

    intY 3

'if the conditions are not true

Else

    'set intY equal to -1

    intY = -1

'end of if condition

End If

Assume “intX” is 5

If intX < 10 Then 'checks 5<10...

Answer 9

Chapter 4.4, Problem 4.7CP

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'checking intX is less than 20

Elseif intX < 20 Then

    'set intY equal to 1

    intY = 1

'checking intX is less than 30

Elseif intX < 30 Then

    'set intY equal to 2

    intY = 2

'checking intX is less than 40

Elseif intX < 40 Then

    'set intY eual to 3

    intY 3

'if the conditions are not true

Else

    'set intY equal to -1

    intY = -1

'end of if condition

End If

Assume “intX” is 5

If intX < 10 Then 'checks 5<10...

Answer 10

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'end of if condition

End If

'checking intX is less than 20

If intX < 20 Then

    'set intY equal to 1

    intY = 1

'end of if condition

End If

'checking intX is less than 30

If intX < 30 Then

    'set intY equal to 2

    intY = 2

'end of if condition

End If

'checking intX is less than 40

If intX < 40 Then

    'set intY eual to 3

    intY 3

'end of if condition

End If

Assume “intX” is 5.

If intX < 10 Then 'checks 5<10...

Answer 11

Explanation of Solution

The given code:

'checking intX is less than 10

If intX < 10 Then

    'Set intY equal to 0

    intY = 0

'end of if condition

End If

'checking intX is less than 20

If intX < 20 Then

    'set intY equal to 1

    intY = 1

'end of if condition

End If

'checking intX is less than 30

If intX < 30 Then

    'set intY equal to 2

    intY = 2

'end of if condition

End If

'checking intX is less than 40

If intX < 40 Then

    'set intY eual to 3

    intY 3

'end of if condition

End If

Assume “intX” is 5.

If intX < 10 Then 'checks 5<10...

Answer 12

Expert Solution & Answer

Answer 13

Expert Solution & Answer

Answer 14

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 15

Ch. 4.2 - Prob. 4.1CP Ch. 4.2 - In the following If Then statement, assume that...Ch. 4.2 - Do both of the following If Then statements...Ch. 4.2 - Prob. 4.4CP Ch. 4.3 - Prob. 4.5CP Ch. 4.4 - The following If Then ElseIf statement has...Ch. 4.4 - Prob. 4.7CP Ch. 4.6 - Prob. 4.8CP Ch. 4.7 - Prob. 4.9CP Ch. 4.7 - Prob. 4.10CP

Solution Summary: The author explains how the code checks the first condition "intX 10" and the condition is true.

Concept explainers

Explanation of Solution

Explanation of Solution

Want to see the full answer?

Chapter 4 Solutions