Forum Discussion
Help with a Formula please
Hi, Here is how the sheet looks so far Dip Sampling Rejected Dip Sample Cleansed Dip Sample Total Success Rate To Success Rate Target 1 4 5 80.00% 96% 0 0 0 ...
Hi, to both!
You could use this formula too (non CSE) in E2:
=IF(B2="","",IFERROR(B2+MATCH(F2,INDEX((B2+ROW($1:$10000))/(C2+ROW($1:$10000)),)),"Target Met"))
And drag it down. Blessings!