Hi
I have a row of cells with values as 1,2 or blank cells.
If A2 cell has value 2, B2 cell has blank value & then C2 has value 2, I need true in cell D2. Can we arrive true in cell D2 by using a formula?
If A2 cell has value 2, B2 cell has blank value & then C2 has value 1, I need false in cell D2.
Basically, I need the formula to ignore blank cells & check if the cells that have values have equal values or not.
For example, please see attached file.
Thanks in advance!
Make sure you data is NUMBER.
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Perhaps in J2 and copy down.
=IF(AND(COUNTIF(A2:I2,1)>0,COUNTIF(A2:I2,2)>0),FALSE,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.
HI
in your sheet you can use below formula in Cell J2 & Copy down
=IF(MAX(A9:I9)=MIN(A9:I9),"TRUE","FALSE")
Click on * below if you find this helpful
Thanks,
A
or may be..
Formula:
Please Login or Register to view this content.
you can extend A:C
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Thank you all for the quick help!
I have 1 more thing which I forgot to mention. Apart from this condition, if all cells are blank, I need false to be shown. Would that be possible?
Right now, in all your formulas, if all cells are blanks, then it shows true as answer. Is it possible to show flase instead of true for this condition?
Thanks in advance!
use this
=IF(MAX(A9:I9)=0,"FALSE",IF(MAX(A9:I9)=MIN(A9:I9),"TRUE","FALSE"))
Last edited by amy_d2; 09-25-2013 at 04:28 AM. Reason: change in formula
Try this..
=OR(SUMPRODUCT((($A2:$C2<>"")/COUNTIF($A2:$C2,$A2:$C2&"")))=1,COUNTBLANK(A2:C2))
BTW.. if one cell is filled and other 2 are blank.. what should be the output.. ??
I would need that as true. Thanks!Originally Posted by Debraj Roy
All cells blanks=False
few cells blanks, other cell or cells with value 2=True
few cells blanks, other cell or cells with value 1=True
few cells blanks, other cells with value 1 & 2=False
and above is working as per requirement.. ??
I tried your formula but all rows are showing true.Even for rows where there are 1's & 2's.
array formulas = CTRL + SHIFT + ENTERPlease Login or Register to view this content.
Just for testing...
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks