Sep 27 2019 10:06 AM - edited Sep 27 2019 10:10 AM
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
Sep 27 2019 10:33 AM
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")))
Sep 27 2019 11:29 AM - edited Sep 27 2019 11:30 AM
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