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.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!