Hi guys, would you know what do we add to the existing formula to say:
IF there are more than 3 x "y" show 100%, otherwise use existing formula ?
Please see the screenshot, and I also include the formula here:
=IFERROR(COUNTIFS(A3:D3,"Y")/3,0)
Thanking in advance!
2017-10-26_1518.png
Try
=IFERROR(MIN(1,COUNTIFS(A3:D3,"Y")/3),0)
or simply
=MIN(1,COUNTIFS(A3:D3,"Y")/3)
May be
Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
You are dealing with 4 cells,
Would it not be
Formula:Please Login or Register to view this content.
1 would make it 100%Originally Posted by shukla.ankur281190
Thank you for the rep!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thank you so much for your help, guys! Mission accomplished :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks