Using nested if statements, create an Excel worksheet that will convert meters to one of the following

units: inches, feet, miles, depending on the magnitude of the given value. Display the appropriate unit in

the adjacent cell. Use the following rules to determine which unit will be shown:

• If the given value is less than 0.5 meters, convert to inches.

• If the given value is greater than or equal to 0.5 meters but less than 500 meters, convert to

feet.

• If the given value is greater than or equal to 500 meters, convert to miles.

Use the worksheet to carry out the following conversions:

a) 127 meters

b) 0.34 meters

c) 12400 meters

d) 48 meters