SO HAPPY I FOUND THIS. I have been searching everywhere for days to find out how to go about finding %'s of an overall total. I had no idea it could be this easy to input this into excel. THANK YOU SO MUCH
Try it without hitting F4 and you will see that the formula will not work. What F4 does to the cell reference is to put $ signs in the cell references to lock the cell reference on D5, so that when we copy the formula the denominator is D5.
people.highline.edu/mgirvin/ExcelIsFun.htm
It's great to hear someone enthusiastic about their work - keeps my attention! Thanks for the lessons!
SO HAPPY I FOUND THIS. I have been searching everywhere for days to find out how to go about finding %'s of an overall total. I had no idea it could be this easy to input this into excel. THANK YOU SO MUCH
Glad this helps : )
I am glad that it is helpful.
No PowerPointIsFun...
You are welcome!
Thanks! I am glad that you like it!
You are welcome!!
I am glad it made you laugh!
Try it without hitting F4 and you will see that the formula will not work.
What F4 does to the cell reference is to put $ signs in the cell references to lock the cell reference on D5, so that when we copy the formula the denominator is D5.
Excellent!
hey, what formula can I apply in excel if I want to get proportion from percentage per unit area like (cm2)?
awesome tut. I laughed so hard at 1:00. TABBBB that made my day thanks!
Thank you.
You are welcome!
Great Job... is there a 'PowerpointsFun' ? :-)
sorry, but i didn't get why F4 before hitting enter? 1:51
You are welcome!
You are welcome!
You are welcome!
You are welcome!