Formula Needed to Determine An Accurate Percentage

[Cansa]

I am currently working on percentages and I was wondering if there would be a Macro that I could use to Formulate what I need Automatically....Attached is an example of what I am looking for. The Notes in the Green explain what I am looking for also. A Macro that could determine how to formulate the percentage as so,

the # of Dies (A2) is 3 then J4 = B4/C4+D4+E4

Please let me know if you need anymore clarity!

Regards,
Cansa

[AB33]

I do not think you need a macro . You need ifs statements.Please see attached.

[Cansa]

Thank you! It is working nicely