LinkBack URL
About LinkBacks
HI
last question of the day
Column B is populated with either true or false
Column C is populated with either true or false
I want column D, to come back true, if both column B AND Column C are true, if not then then return False
HI
last question of the day
Column B is populated with either true or false
Column C is populated with either true or false
I want column D, to come back true, if both column B AND Column C are true, if not then then return False
Last edited by masond3; 09-20-2013 at 05:07 AM.
=and(b1=true,c1=true)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Just another side note.
False is 0 and all other is TRUE..
Formula:
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Another couple of alternatives
=B1*C1=1
=COUNTIF(B1:C1,TRUE)=2
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks