paul Wrote:
i must be a bit dim.I would use some"helper" cells to do some figuring
so
that the 115/12 and 225/12 actually just refferred to another cell
which is
"box"/12.I cant figure out tho where (23*A1)/(75*A1) and (3*A1)/(5*A1)
come
from in relation to 115 and 225 respectively.If there is no direct
relationship then they can be looked up in a table and referred to in
your
formula.I find that the easist way to figure these things out is to
proceed
one step at a time ,making each calcuation"automatic".Once you have
done that
you can combine all your seperate steps together into one forula
--
paul
remove nospam for email addy!
HeHe... you're not dim ... I only chanced upon that myself...
You see, if you do 2 * (3/5) you get 1.2 .... however, if you want to
multiply by 2 ...* BUT *keep the 3/5 in tact .... now you need to do
(3*2)/(5*2) which naturally brings you back to 3/5.
That's why my math is done that way. You're not dim, I came upon that
on a Euricka moment. =)
--
rjmckay
------------------------------------------------------------------------
rjmckay's Profile:
http://www.excelforum.com/member.php...o&userid=16880
View this thread:
http://www.excelforum.com/showthread...hreadid=550681