 • 441K Members
• 4,693 Online
• 529K Conversations

Deleted
Not applicable

# Example mathematical formula Excel

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

# Re: Example mathematical formula Excel

Hello,

Below formula would work:

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

# Re: Example mathematical formula Excel

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

# Re: Example mathematical formula Excel

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