I'm looking to create a chart where Column A is a number and Column B is Column A divided by 272, expressed as a percentage. I thought it would be easy to do using "=QUOTIENT(A1,272)", setting the field to express as a percentage. For some reason it will only show as 0.00%, unless the number in Column A is over 272.
Does anyone know how I might solve this?
QUOTIENT only returns the integer portion of the result... so always a whole number.
Try
=A1/27200
formatted as percent
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Per Excel Help:
"QUOTIENT function
Returns the integer portion of a division. Use this function when you want to discard the remainder of a division"
Is that what you want to do?
NBVC, your answered worked perfectly! Thank you kindly. Just saved me loads of time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks