i am trying to do the percentage of an amount on the excel sheet, without using a calculator
2006-09-23 20:17:22 · 9 answers · asked by hotgal3 1 in Computers & Internet ➔ Software
yes you can do it by
>insert >>fx/function >> set it to most recently used>> pmt..>> this cld help you out with required rates and tht all
or
simply set a formula for percentage(by customizing it so)
hope this wld help!!
2006-09-23 20:30:30 · answer #1 · answered by Neeraj Yadav♥ 6 · 0⤊ 0⤋
You can go to format and cells and change any number within a cell to be a percentage - if you wish it to appear on the screen in the percentage format - however, as with previous answer - you need to do the calculation using the = sign
2006-09-23 20:26:55 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Yes. The other posters are correct. Just remember that a formula starts with a equal sign.
A1=£400
B1=£170
What is the difference between the 2 figures listed as a percentage.
=B1/A1*100
which gives 42.5%
2006-09-23 21:08:22 · answer #3 · answered by Siu02rk 3 · 0⤊ 0⤋
In the cell, use the "=" sign and then you can do any calculation you want. You can reference cells by their name- So you if cel A2 contained 20 and cell A3 Contained 40 you could type in cell A5 " =((A2/A3*100)) That would give you 50%
2006-09-23 20:23:47 · answer #4 · answered by P R 2 · 1⤊ 0⤋
press = sign before all calculations and its that simple, also if you want to find out 36% of $500 type in =500x0.36, hope it helps
2006-09-23 20:30:32 · answer #5 · answered by Anonymous · 0⤊ 0⤋
Type the following formula in the cell B1: =A1*.3
2016-03-27 06:03:12 · answer #6 · answered by Anonymous · 0⤊ 0⤋
Dont think I can go one better than that answer you have just got.
2006-09-23 20:27:01 · answer #7 · answered by Out of Interest 1 · 0⤊ 1⤋
try yourself, easy!
2006-09-23 20:27:37 · answer #8 · answered by djdjdij 1 · 0⤊ 1⤋
yes i do.
2006-09-23 20:38:35 · answer #9 · answered by Anonymous · 0⤊ 2⤋