Could someone please look at our multiple IF statement to see why it isn't working properly?
I've attached a file that has the statement in Column-A of the "RE RO RL CREDIT CARDS" worksheet.
Thank you for the help!
Could someone please look at our multiple IF statement to see why it isn't working properly?
I've attached a file that has the statement in Column-A of the "RE RO RL CREDIT CARDS" worksheet.
Thank you for the help!
maybe
=IF(OR('ALL CREDIT CARDS'!A3={"R/E","R/O","R/L"}),'ALL CREDIT CARDS'!A3,"")
how about
RE,RO and Rl only without the / ?
you can also use
=IF(ISERROR(SEARCH("R",'ALL CREDIT CARDS'!A3)),"",'ALL CREDIT CARDS'!A3)
Last edited by vlady; 01-20-2014 at 09:29 PM.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
That's the ticket ... it works great! Thank you for the help. We were getting nowhere!!
Nice to hear that.
Regards,
Vladimir
The formula as written has only the TRUE parts of the IF statement without any FALSE parts except at the end. In addition, the values being looked up on the All Credit Cards worksheet don't match the values in the formula.
Try this:
Formula:Please Login or Register to view this content.
A much shorter version is:
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 01-20-2014 at 09:55 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
You have a "/" in the if stmt, but don't have it in the cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks