Here's what I want:
If any of the these 3 cells (B,F.G) say completed, and cell J is text then give 1 otherwise 0 in cell AN
Here's what I did but keep getting all 0's:
=IF((AND(istext(J57(OR(B57="Completed", F57="Completed", G57="Completed"))),1,0)))
excel autocorrected it to: =IF((AND(ISTEXT(J2*(OR(B2="Completed",F2="Completed",G2="Completed"))))),1,0)
Any help would be appreciated.
Try this:
Formula:
Please Login or Register to view this content.
EDITED TO INCLUDE THIS ALTERNATIVE
Technically, you could use this:
Formula:Please Login or Register to view this content.
Is that something you can work with?
Last edited by Ron Coderre; 05-16-2014 at 03:42 PM.
This is cell N1 formula:
Formula:Please Login or Register to view this content.
I think what you want is:
=IF(AND(ISTEXT(J2),OR(B2="Completed",B2="Completed",B2="Completed")),1,0)
Click on star (*) below if this helps
Yes this works. I see where I made the mistake. Thank you!
Glad you got something you can use!
Be sure to mark this thread as SOLVED (from the Thread Tools menu)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks