=if formula

[bennerkaj]

so i am trying to make my school life easier and i thought excel was the way...

i want excel to tell me where a zone is on a roof.. so fx 0 to 6.9 is a angle and 0.50 means the middle of the roof

but i have no ide how..

cell A1 is 0 to 6.9 = "0.50" But if it is 7 to 9,9 = "0.66" but if 10 to 29.9 = "0,75" and if it is greater than 30 = "1.0" 

=if A1=0<6.9,"0.50",if=7<9.9,"0.66",if=10<29.9,"0,75",if>30,"1.0"

i have no idear what the formula looks like so hope you guys can help

[#2]

@bennerkaj 

As variant that could be 

=LOOKUP(A1,{0,7,10,30},{0.5,0.66,0.75,1})

if with IF

=if(A1<7,0.50,if(A1<10,0.66,if(A1<30,"0,75","1.0")))

[#3]

@bennerkaj 

Hi

another option

you can use a VLOOKUP function with hard coded table array, as follows:

=VLOOKUP($A$1,{0,0.5;7,0.66;10,0.75;30,1},2,1)

Hope that helps

Nabil Mourad