Which is the fastest method of sharing public folders?
1 answer:
You might be interested in
Answer:
see explaination
Explanation:
Please find the screenprint and the VBA code. As shown in the screenprint, range B1 is used to enter the number of petals. If you want to use a different cell for petals input, then change the code accordingly.
Also, the VBA code is placed in the Sheet1 module. No new modules are inserted.
Screenprint: see attachment for screenshot
VBA Code:
Private Sub CommandButton1_Click()
Call daisyDecisions
End Sub
Private Sub daisyDecisions()
Dim remainder As Integer
Dim noOfPetals As Integer
noOfPetals = Sheet1.Range("B1").Value
remainder = noOfPetals Mod 2
If remainder <> 0 Then
MsgBox "He/She loves you!!!"
Else
MsgBox "He/She loves you not!!!"
End If
End Sub
The output printed by the code is 18
<h3>The Code Analysis</h3>The flow of the program is as follows:
- The first line initializes a list of numbers named values
- The second line initializes fred to 0
- The third line is an iteration that is repeated for all numbers in the list
- The next statement is a conditional statement that ensures that all 9's in the list are added, and saved in fred
Recall that, the initial value of fred is 0, and there are 2 9's in the list.
So, the computation is:
This means that, the last instruction on line 10 will display 18, as the output
Hence, the output printed by the code is 18
Read more about algorithms at: