ok here is my problem, each company is authorized certain slots for schools now i'm asking for help i need one FORMULA they will calculate the persentage from what they have on HAND to what their authorized,please help,i also added my chart so you can have a better idea with what i need help with.thanks
V/R
David549
Last edited by david549; 04-11-2012 at 10:10 AM. Reason: NEW INFO
I'm not sure I'm getting it... a percentage is just a division
% = ON HAND / AUTHORIZED
And go to CELL FORMAT > NUMBER > PERCENTAGE to make the cell have the corresponding formatting.
Or was it something else? Please explain better if so.
looking at your file....just a few observations/suggestions
1. the "1" you have in B4 is actually text, not a value
2. your formula in H4 starts off by testing B4+C4+D4+E4+F4 with the contents of G4...G4 is the sum of those values, so (if you enter values instead of text), it will always be "true" and return a ""
3. in H4, try using =(M4-K4)/M4 and format it as % (which it already is)
4. if you need to return a blank if any of the cells has no data, use =iferror((M4-K4)/M4,"")
Let me know if this is what you wanted?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks