Question: The Saffir-Simpson hurricane wind scale classifies hurricanes into five categories based on the intensity of their sustained winds.
A category one hurricane has wind speeds between 74 and 95 miles per hour (mph). A category two hurricane has wind speeds between 96 and 110 mph.
A category three hurricane has wind speeds between 111 and 129 mph. A category four hurricane has wind speeds between 130 and 156 mph. A category five hurricane has wind speeds greater or equal to 157 mph.
Q: Prepare a VBA statements that employ a CASE statement to determine what type of hurricane you have based on a given wind speed stored in a variable WIND.