Q39
Single choice
A variable in your report contains the statement:
=If[State] = "California" Then [Sales revenue] * 1.05 Else If[State] = "Colorado" Then [Sales revenue] *
1.1 Else If[State] InList ("DC";"Texas ") Then [Sales revenue] * 1.15 Else If[State] = "Massachusetts" Then
[Sales revenue] * 1.18 Else [Sales revenue]
Sales revenue for Florida is $1,879,159. Which rate is applied to the Florida revenue by the formula?
Please choose the correct answer.
Response: