Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
absolute cell reference - percentage?
hi everyone.
I'm currently stuck on a question for my assignment. I have to make up a formula that requires on absolute cell reference. The question is:
the percentage % of total sales
(employee total divided by total sales this quarter)
i have no data and the formulas for the employee total i came up with are: =SUM(C5+D5+E5) and for total sales: =SUM(F5:F14)
I've been trying to work out a formula for the percentage, but no matter what I've come up with, I keep getting this: #DIV/0!
any help/advice would be great, thanks!
1 Answer
- expletive_xomLv 79 years agoFavourite answer
the reason you get the #DIV/0! error is......"i have no data"....you start the 3rd paragraph above saying that you have no data, and without data, you will be dividing by 0 and get your error.
here is what you need to do
- put data in cell C5....just put in a number, and number except 0
- in F5 copy&paste this formula
=SUM(C5:E5)
- in G5 you need to use your $......the $ is the symbol for "absolute cell reference"...copy&paste this
=F5/SUM(F$5:F$14)
- then use your mouse to select F5 and G5
- click copy
- use your mouse to select F6 down to G14
- click paste
- column G should be formatted as a % (you should have % button on your menu)
- fill in data in columns C, D and E
done
let me know if something isnt working
