I would like to know how multiply one cell with only the decimal part of a number in another. E.G. 2.75 * 32 = 24. This is probably not too difficult but the more I look at it the more complicated I am making it!! Hope someone can help me out - thanks
One way:
=(2.75-INT(2.75))*32
Assuming A1: =2.75 and B1: =32 then use
=(A1-INT(A1))*B1
Thank you both very much, I could have looked at it forever without solving it - thanks again.
or
=mod(a1,1)*b1
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Darren - that's also a nice/clever solution - I'm going to use both!!
it does have a limitation however, wont work with -ve numbers!
Not a problem darren - wont have any but I see what you mean. Good luck with the job hunting.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks