the first formula that I want create sums B2:J2 in K2 to 100% or 1 essentially and the total K2 cannot surpasse 100% or 1. The reason I say 100% or 1 is because the user can enter a percent in cells B2:J2 or a number in decimal format that is less than one.

the second formula I want the user to be to enter a percent or a number in decimal format into cells B2:J2.

That's pretty much it.

I really don't need vba code to do this, I figured a couple of formulas can do the trick.