If anyone can help me on this it would be greatly appreciated.
I need to divide a user entered hieght by several different sizes
the sizes being 3.0m,2.5m, 2.0m, 1.5m, 1.0m and 0.75m
eg; 10m hieght i would need 3 x 3m and 1 x 1m.
I realize this is probably fairly simple but for the life of me i just can't seem to figure out the formula.
Last edited by Dagz; 03-21-2008 at 05:59 AM. Reason: title against rules
Well I am stumped at what you are asking for, am I to assume you have never used excel before??Originally Posted by Dagz
Did you read the forum rules before starting your thread? particularly about titles!!
I'm assuming i need a formula to take a number divide it by 3 rounded down to the nearest whole number,then take the remainder and divide that by 2.5 round down and so on thru the other sizes
Put the sizes to be divided by in one column, say cells B1:B6. 10m could be in A1. In C1, =Rounddown(A1/B1,0). In C2, =Rounddown((A$1-Sumproduct(B$1:B1,C$1:C1))/B2,0) and drag down.
Thanks Darkyam
that formula is exactly what i needed.
thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks