LinkBack URL
About LinkBacks
What am I doing wrong here? This is always triggering the "Else" part of the statement even though both A1 and A2 are 1.
=IF(AND(A1="1",A2="1"), "Both are 1", "Both are not 1")
What am I doing wrong here? This is always triggering the "Else" part of the statement even though both A1 and A2 are 1.
=IF(AND(A1="1",A2="1"), "Both are 1", "Both are not 1")
Get rid of those quotes!
=IF(AND(A1=1,A2=1), "Both are 1", "Both are not 1")
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Try without quotes for the numbersto enusre Excel reads them as numbers and not as text
=IF(AND(A1=1,A2=1),"Both are 1","Both are not 1")
Life's a spreadsheet, Excel!
Say thanks, Click *
Is the value of A1 and A2 Numerical or text?
You have it as text
try
=IF(AND(A1=1,A2=1), "Both are 1", "Both are not 1")
Ahaaa!!! That was my problem. Didn't need the quotes. Thanks!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks