Amateur Excel User Needing Help On First University Assignment

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

=If (AND (B2> 0, B2 <1100),CONCATENATE (B2,"troposphere"),"")

Then nest your other if statements.
Does this help?

Regards

Dan.

Sorry,

Forget the CONCATENATE part,

Just use "the word"

Originally Posted by Sambo kid

I think you'll be asked soon to rewrite your thread title since it does not conform to the forum rules.

That being said, it seems to me that B2 cannot be less than B2, a cell can't be less than itself.
Now, based on this...
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.

It seems to me you want something like (assuming your values are in Col B)
=if(B2<=11000,"Tropoause",if(b2<15000,"stratosphere","invalid entry"))

I think I caught all of it.

EDIT: missed your last part, and I really don't know about that "bevel" part.

This works apart from the part where it needs to display troposphere between 0 and 11000

Originally Posted by Sambo kid

Sorry, tropopause and troposphere looked the same.
try this instead
=if(B2<11000,"Troposphere",if(b2=11000,"tropopause",if(B2<15000,"stratosphere","invalid entry")))

That worked fantastically!! Thanks ever so much!