I am using Microsoft Excel and would like to use vb code if possible to do function below.

My problem is I have no idea how to write code and my reason for this request is that Excel only allow a certain amount of arguments.
I will be adding much more in the future.

I need the result to the first IF/OR Statement to be the number "1" if True else nothing.
and for the second IF/OR Statement to be the "0" if True else nothing.


Appreciate any assistance or guidance.