LinkBack URL
About LinkBacks
I am trying to divide various dollar amounts into three parts. Example, 1.00 would be .33 .33 .34 10.00 would be 3.33 3.33 3.34 etc.. Thanks
Divide dollars into three parts
I am trying to divide various dollar amounts into three parts. Example, 1.00 would be .33 .33 .34 10.00 would be 3.33 3.33 3.34 etc.. Thanks
If your values are in column A, then in B1 and C1 you can use the formula:
=FLOOR(A1/3,0.01)
In D1, just use
=A1-B1-C1
If you simply used =A1/3, =A1/3 and =A1-B1-C1 you would get incorrect results (1 would become .33/.33/.33, not .33/.33/.34)
Dollar problem
Thanks pjoaquin. I knew it was simple but could not figure it out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks