Jan 07 2020 04:33 AM
Hello all,
first of all best wishes for 2020.
I am very amateur with excel and I would need help with a formula.
I have a very simple board with 3 posibilities, yes, no, N/A total of 10 values
N/A is a discriminating value.
-if n/a is "0" the total of values is 10
-if n/a is "1" the total of values is 9
what i am trying to do is get a percentage based on de condition of "c2"
if (c2 is equal to 0, e2 is "x" percentage of d2) otherwise (c2 is equal to 1, e2 is "x" percentage of (d2-1).
I hope I have been able to explain myself correctly and is understandeble for you all.
If someone could help me because i have spent already long time trying to do it that i cant figure alone.
Thanks in advance for you help.
Jan 07 2020 04:52 AM - edited Jan 07 2020 04:53 AM