Question: Please answer ASAP! I need help coding this in EXCEL developer. Thanks. (60 points) The Saffir-Simpson hurricane wind scale classifies hurricanes into five categories based
Please answer ASAP! I need help coding this in EXCEL developer. Thanks.

(60 points) 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 (mhp). 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. Write VBA statements that employ a CASE statement AND an If statement to determine what type of hurricane you have based on a given wind speed stored in a variable WIND, Flowchart is needed
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
