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
- Feeding frenzy 2 download - Download - Arcade
- Display two columns in data validation list but return only one - Guide
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!
