Hi All,

Brief intro, I'm Joe, 19 y/o Aerospace Engineering Student at the University of Liverpool.

I have been set my first coursework assignment.

I'll list the parts I'm slightly confused with and then be more specific with what is wrong.

I need to have a user input box that when a value is entered a number of calculations are carried out 7 results are given using the entered value to calculate these values. This part shouldn't be too difficult, the bit I am struggling on is the fact a word needs to be displayed based on the value entered by the user. I am currently using the =IF() function for this, but it seems to only allow one parameter.

I need it to follow these conditions.

If <entered value> is greater than 0 and less than 11000 then the word displayed is "troposphere",
if <entered value> is equal to 11000 then "tropoause" is displayed
if <entered value> is greater than 11000 and less than 15000 then "stratosphere" is displayed,
if <entered value> is greater than 15000 then "Invalid Entry" is displayed.

I have started this and have currently got so far as

=IF(B2<B2>"",IF(0<B2<11000,"Troposphere",IF(B2=11000,"Tropopause","")),"")

but the 0<B2<11000 part doesn't work and troposphere is never displayed.

Also, last question, is it possible to have a bevel effect on certain cells to make them stand out and is it possible to "lock" cells from a user inputting a value and only having the one input cell allowing a user to enter a value?

Thanks for the help,

Joe