hello,
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.
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.