I need to get 80% of a number in a cell ---for example if cell "A1" has "$23,343.26" in it and I want cell "A2" to be 80% of cell "A1" what formula do I put in the formula line of "A2" ----I tried "=A1(.80)" but that gets me an error message. Sorry for such a simplistic question. ---jaes.
Here!
=A1*80%
or
=A1*.8
Cheers!
Deep Dave
Besides the examples Deep Dave gave, if you are going to continually use that same percentage in multiple formulas you can enter it into a cell and then reference that cell in your formulas. You then can change the one cell and all your formulas will reflect that change. By typing the $ in the cell reference I can type the formula once and copy it down and the reference to the cell with the percentage will stay the same while the other cell in the formula will change.
PercentFormulas.jpg
Last edited by skywriter; 08-19-2015 at 03:14 AM.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Thank you "NeedForExcel" and "skywriter" for the quick reply. I wanted to get this spread sheet done tonight/this morning --and I ran into a mental block ----thanks so much. --jaes
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks