Consider the following code:
Result= input_number Mod 7
If (Result > 0) Then
Cells(1,1).Value = 3
NextResult = input_number Mod 5
If (NextResult > 0) Then
Cells(1,1).Value = 2
Cells(1,1).Value = 1
What will be the content of cell A1 if input_number equals 56?
I picked A, am I right??
Consider the following custom function:
Public Function Discount(quantity As Integer) As Single
IF (quantity <= 5) Then Discount = 0
IF (quantity <= 10) Then Discount = 0.1
Discount = 0.15
Suppose you enter the following formula in B1: =Discount(12). What will be the result in B1?
I picked C, am I right?
Consider the following code segment:
SumTotal = 1
IF (SumTotal < 5) Then
SumTotal = SumTotal + 3
What will be the value of SumTotal when the program comes out of the loop?
I picked B, am I right??
thanks for all your help