hello,
Im trying to figure out a formula to auto-calculate percentage of a few cells.
If you look at the attached image... Im trying to insert:
A1's percent of A4 into A5
A2's percent of A4 into A6
A3's percent of A4 into A7
Thanks in advance to anyone that can lend me a hand, I really appreciate it.
Try putting this formula in A5
=A1/A$4
format A5 as % and copy formula down to A7
Using your posted example....
Try this:
• Select cell A5
• Type: =
• Click on cell A1
• Type: /
• Click on cell A4
• Press the [F4] key one time
(That will put dollar signs ($) in the A4 reference to "lock" it)
• Press [Enter]
That's the basic formula: =A1/$A$4
Next...set the format to percent:
• Select cell A5
• Hold down [Ctrl]+[Shift] and press [%]...(on the [5] key)
Copy cell A5 and paste down as far as you need
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks