Using VBA program and using excelWrite a function which takes as input a planet name and returns a message as follows:If the planet is not on the list then return “Pick another planet”.If the temperature is less than -80 or greater than +80, or the oxygen level is less than 10, or the radiation level is Lethal, return “x is not habitable” where x is the name of the planet.If the temperature is between 0 and 30, the oxygen level is at least 20, and the radiation level is None, return “x is ideal” where x is the name of the planet.Otherwise return “x is habitable, but not ideal” where x is the name of the planet.

In this question we have to write a VBA code for the function which takes input a planet name and…

Answered: Using VBA program and using excel…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Using VBA program and using excel

Write a function which takes as input a planet name and returns a message as follows:

If the planet is not on the list then return “Pick another planet”.
If the temperature is less than -80 or greater than +80, or the oxygen level is less than 10, or the radiation level is Lethal, return “x is not habitable” where x is the name of the planet.
If the temperature is between 0 and 30, the oxygen level is at least 20, and the radiation level is None, return “x is ideal” where x is the name of the planet.
Otherwise return “x is habitable, but not ideal” where x is the name of the planet.

Expert Solution

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions