Show Percentage of value

[shifty]

For example
IF i start with 100 i need the next cell below to show what 5% off 100 is.
So the answer sould be 5.
Thanks

 

[Gary''s Student]

=.05*A1

 

[shifty]

=.05*A1

Thanks
Although 5% would be 0.05

 

[Niek Otten]

You can also use

=5%*A1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
|
| "Gary''s Student" wrote:
|
| > =.05*A1
| > --
| > Gary''s Student - gsnu200766
|
|
| Thanks
| Although 5% would be 0.05

 

[David Biddulph]

Yes, so you can use =5%*A1
--
David Biddulph

Thanks
Although 5% would be 0.05

 

[Ball4v]

For example
IF i start with 100 i need the next cell below to show what 5% off 100 is.
So the answer sould be 5.
Thanks

 

[Ball4v]

I am trying to remember how to figure the percentage of 2 numbers: For
example I have 545 and want to know what percent 379 is of the 545. How would
I do that manually and then formulate to excel spread sheet?

 

[Roger Govier]

Hi

With 545 in A1, and 379 in B1, enter in C1
=B1/A1
Format C1 with Format>Cells>Number>Percentage