Scorecards

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?
 
J

JE McGimpsey

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%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

scorecard 2
drag formula across making chgs on the way 5
Excel does not accept text format! 0
Weigh tasks 0
Calculation Based on Dynamic Variables (What-if Scenario) 0
returning blank cell in an if statement 2
Word macro that can call cells out of Excel for a find and replace 0
Moving Macros to the Application Level 2

Top