Scorecards

  • Thread starter Thread starter New User
  • Start date Start date
N

New User

I am new to excel and I am trying to learn how to create
a scorecard. For example, I want the end user to be able
to simply type a "1" in a cell but I want it to calculate
it as a certain %. So that the subsequent cell can
multiply the % by the weight to give a calculation. Can
anyone help?
 
Not really sure what you're driving at, but perhaps this will give you
something to shoot down...

If you want to weight the value in A1 by a factor of 200%, for instance,
then in A2 you enter

=A1 * 200%
 
Back
Top