Help with creating a formula...

  • Thread starter Thread starter Battalion IMO-1
  • Start date Start date
B

Battalion IMO-1

Hi everyone,

I am trying to set up an excel spreadsheet that does the following
calculation:

(enter Number) Is Percentage of (enter
number)

User Inputted Number Calculated by excel User Inputted
Number

Any suggestions or tips?

Thanks in advance!

Rick D.
 
If I understand this correctly, you want to divide the # in Column A by
Column C and display it as a percentage

Column A Column B Column C
1 Enter column titles in this row
2 Entered # B2 ..Calculated # Entered #

In cell A2 and C2 you enter the values as you want them.
In cell B2, enter =A2/C2
Format column B to display as a percent
 
Thanks Barb!! That's exactly what I was looking for!

I guess I was over-analyzing the problem. Sometimes the basics work best!

Rick D.
 
Back
Top