 • 512K Members
• 6,297 Online
• 608K 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
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies