hi,
i need your help about a formula for below;
i have data in A2:AL2
i want to have in AM3, if A2:AL2 has no empty cells (even they have formulas in them but shows empty) AND if A2:AL2 has no "?" question mark = if both conditions are ok, it must show 1, if one missing, 0
thank you in advance.
This should do what you need
Formula:
Please Login or Register to view this content.
Ferdy
Remember to mark as Solved and give out rep.
Thank you very much really.
You're welcome.
If that takes care of your initial question, please go to the top of your post, Thread Tools and then Mark the thread as solved.
Dear Ferdy,
Now i noticed that, when cell has formula but shows empty, this solution considers it also a full cell. How can we change the formula accordingly?
Try this modification to the formula:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you very much Jete
You're Welcome. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks