Here is your formula
Let me know if you have any questions
I am not sure what that means, especially if I do not know what values you have in the B, and C cells.
I will be happy to look further into this but I think I have answered your original question. In the meantime thanks in advance...
I found the problem and was able to correct the formula.
The problem is you asked that all three cells should have values, and if cell D2 has a value then B and C cannot be 100%