Home

Example mathematical formula Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-282841%22%20slang%3D%22en-US%22%3EExample%20mathematical%20formula%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282841%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EI%20have%20to%20write%20this%20formula%20in%20excel%20365%2C%20if%20the%20value%20of%20cell%20A1%20is%26gt%3B%2010%20and%20%26lt%3B20%20shows%20the%20value%20contained%20in%20cell%20A2.%20W%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%3Ehat%20is%20the%20solution.%3C%2FSPAN%3E%20Thank%20you%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-282841%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-283009%22%20slang%3D%22en-US%22%3ERe%3A%20Example%20mathematical%20formula%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-283009%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20of%20all%20I%20am%20using%20the%20Turkish%20version%20of%20Excel%20so%20the%20%22%3B%22%20signs%20in%20the%20formula%20may%20need%20to%20be%20changed%20to%20%22%2C%22.%20secondly%20if%20you%20mean%20using%20the%20same%20formula%20in%20a%20different%20cell%20with%20different%20control%20it%20can%20be.%20How%20ever%20if%20you%20want%20to%20check%20a%20second%20condition%20when%20the%20first%20one%20is%20not%20true%20you%20need%20to%20write%20nested%20ifs%20like%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND(A1%26gt%3B10%2C%20A1%26lt%3B10)%3BA2%3BIF(AND(A3%26gt%3B20%2C%20A3%26lt%3B40)%3BA5%3B%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eor%20if%20you%20have%202019%20version%20you%20can%20use%20single%20command%20(not%20sure%20though)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFS(%3CSPAN%3EAND(A1%26gt%3B10%2C%20A1%26lt%3B10)%2CA2%2C(AND(A3%26gt%3B20%2C%20A3%26lt%3B40)%2CA5)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282983%22%20slang%3D%22en-US%22%3ERe%3A%20Example%20mathematical%20formula%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Eto%20add%20the%20same%20formula%20for%20another%20cell%3F%3C%2FSPAN%3E%3CSPAN%3EExample%3A%20%3D%20IF%20(AND%20(A1%26gt%3B%2010%3B%20A1%20%26lt%3B20)%3B%20A2%3B%20%22%22)%20(A3%26gt%3B%2020%3B%20A3%20%26lt%3B40)%3B%20A5%3B%20%22%22).%3C%2FSPAN%3E%3CBR%20%2F%3Ethank%20you%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282847%22%20slang%3D%22en-US%22%3ERe%3A%20Example%20mathematical%20formula%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282847%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20formula%20would%20work%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND(A1%26gt%3B10%3BA1%26lt%3B20)%3BA2%3B%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

I have to write this formula in excel 365, if the value of cell A1 is> 10 and <20 shows the value contained in cell A2. What is the solution. Thank you

3 Replies

Hello,

 

Below formula would work:

 

=IF(AND(A1>10;A1<20);A2;"")

to add the same formula for another cell?Example: = IF (AND (A1> 10; A1 <20); A2; "") (A3> 20; A3 <40); A5; "").
thank you

 

First of all I am using the Turkish version of Excel so the ";" signs in the formula may need to be changed to ",". secondly if you mean using the same formula in a different cell with different control it can be. How ever if you want to check a second condition when the first one is not true you need to write nested ifs like

 

=IF(AND(A1>10, A1<10);A2;IF(AND(A3>20, A3<40);A5;"")

 

or if you have 2019 version you can use single command (not sure though)

 

=IFS(AND(A1>10, A1<10),A2,(AND(A3>20, A3<40),A5)

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