Which rate is applied to the Florida revenue by the formula?

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?
A . 1.00
B . 1.05
C . 1.10
D . 1.15
E . 1.18

View Answer

Answer: A