 • 441K Members
• 8,561 Online
• 529K Conversations

## =if formula

Occasional Visitor

# =if formula

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 Replies

# Re: =if formula

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")))``

# Re: =if formula

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies