Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

answer the following QUESTION 2 On the following VBA Code the yellow part, represent what? Sub IfStatement40) Example of nested ifs. Dim cell As Range

answer the following
image text in transcribed
QUESTION 2 On the following VBA Code the yellow part, represent what? Sub IfStatement40) Example of nested ifs. Dim cell As Range Const cutoff = 80 Go down Employee column. If all scores for a Employee are greater .Than cutoff, boldface the Employee number. Note the indenting. It is crucial for readability! For Each cell In wsData Range("Emplovee") If cell.Offset(0, 1).Value > cutoff Then If cell Offset(0, 2).Value = cutoff Then If cell.Offset(0, 3) Value cutoff Then cell. Font Bold = True End If End If End If Next End Sub A straitght logic structure A nested if Structure using else A nested Loop structure A nested if structure without else

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

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions