Hi,
Can you help please, I would like to have these 3 options -
Two cells A1 - B1 both cells contain text show as "1" in cell C1
Two cells A1 - B1 A1 contains text, no text in B1, show as "1" in cell C1
Two cells A1 - B1 A1 contains no text, B1 contains text, show as "1" in cell C1
Thank you
Try =IF(OR(TYPE(A1)=2,TYPE(B1)=2),1,"")
v A B C 1 ABC DEF =IF(AND(ISTEXT(A1),ISTEXT(B1)),1,"") 2 ABC 1 =IF(AND(ISTEXT(A2),ISNONTEXT(B2)),1,"") 3 1 ABC =IF(AND(ISNONTEXT(A3),ISTEXT(B3)),1,"")
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
OR Can try below
=IFERROR(IF(A1+B1,"",""),1)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi Alan that works a treat - Cheers
Really informative Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks