Home

=if formula

%3CLINGO-SUB%20id%3D%22lingo-sub-879563%22%20slang%3D%22en-US%22%3E%3Dif%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879563%22%20slang%3D%22en-US%22%3E%3CP%3Eso%20i%20am%20trying%20to%20make%20my%20school%20life%26nbsp%3Beasier%20and%20i%20thought%20excel%20was%20the%20way...%3C%2FP%3E%3CP%3Ei%20want%20excel%20to%20tell%20me%20where%20a%20zone%20is%20on%20a%20roof..%20so%20fx%200%20to%206.9%20is%20a%20angle%20and%200.50%20means%20the%20middle%20of%20the%20roof%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20i%20have%20no%20ide%20how..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecell%20A1%20is%200%20to%206.9%20%3D%20%220.50%22%20But%20if%20it%20is%207%20to%209%2C9%20%3D%20%220.66%22%20but%20if%2010%20to%2029.9%20%3D%20%220%2C75%22%20and%20if%20it%20is%20greater%20than%2030%20%3D%20%221.0%22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3Dif%20A1%3D0%26lt%3B6.9%2C%220.50%22%2Cif%3D7%26lt%3B9.9%2C%220.66%22%2Cif%3D10%26lt%3B29.9%2C%220%2C75%22%2Cif%26gt%3B30%2C%221.0%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20no%20idear%20what%20the%20formula%20looks%20like%20so%20hope%20you%20guys%20can%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-879563%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879632%22%20slang%3D%22en-US%22%3ERe%3A%20%3Dif%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879632%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416455%22%20target%3D%22_blank%22%3E%40bennerkaj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20that%20could%20be%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DLOOKUP(A1%2C%7B0%2C7%2C10%2C30%7D%2C%7B0.5%2C0.66%2C0.75%2C1%7D)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eif%20with%20IF%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3Dif(A1%26lt%3B7%2C0.50%2Cif(A1%26lt%3B10%2C0.66%2Cif(A1%26lt%3B30%2C%220%2C75%22%2C%221.0%22)))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879730%22%20slang%3D%22en-US%22%3ERe%3A%20%3Dif%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879730%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416455%22%20target%3D%22_blank%22%3E%40bennerkaj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3Eanother%20option%3C%2FP%3E%3CP%3Eyou%20can%20use%20a%20VLOOKUP%20function%20with%20hard%20coded%20table%20array%2C%20as%20follows%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22arial%20black%2Cavant%20garde%22%20size%3D%224%22%3E%3CSTRONG%3E%3DVLOOKUP(%24A%241%2C%3CFONT%20color%3D%22%23FF0000%22%3E%7B0%2C0.5%3B7%2C0.66%3B10%2C0.75%3B30%2C1%7D%3C%2FFONT%3E%2C2%2C1)%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
bennerkaj
Occasional Visitor

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

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

 

@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

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