Looking up 2 columns and displaying 3rd column on new sheet
Closed
mikequick
Posts
1
Registration date
Monday July 31, 2017
Status
Member
Last seen
July 31, 2017
-
Jul 31, 2017 at 12:11 PM
Blocked Profile - Jul 31, 2017 at 04:52 PM
Blocked Profile - Jul 31, 2017 at 04:52 PM
Related:
- Looking up 2 columns and displaying 3rd column on new sheet
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Plants vs zombies 2 pc download - Download - Strategy
- Red dead redemption 2 free download - Download - Action and adventure
1 response
The syntax for AND is as follows:
=AND(LogicTest1,LogicTest2)
So, if logictest1 and logictest2 is true, returns true.
Now, you can add in an IF, for:
=IF(AND(A2<A3,A2<100),A2,False)
The above code, will place the value of A2, into what cell is testing for the value, as long as A2 is less than A3, AND A2 is Less than 100.
I hope this helps you out!
=AND(LogicTest1,LogicTest2)
So, if logictest1 and logictest2 is true, returns true.
Now, you can add in an IF, for:
=IF(AND(A2<A3,A2<100),A2,False)
The above code, will place the value of A2, into what cell is testing for the value, as long as A2 is less than A3, AND A2 is Less than 100.
I hope this helps you out!