Hello,
I have a formula to calculate the ratio between 2 cells. here it is:
=AF3/GCD(AF3:AI3) & ":" & AI3/GCD(AF3:AI3)
the problem is that it gives the ratio in its simplest form. e.g. cell AF3=15 and cell AI3=30,
the answer would be 1:2.
I want it to be 15:30
Thanks
In your example, what's in AF3 and AI3?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
If you want to keep the original values and not change them just concatenate the cells thus
=AF13&":"&AI3
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
perfect.
cheers special-K
LOL, that's what I was getting to but thought there must be something I'm not seeing here.
lol. dont worry, I'm very confident you know how to do it.Originally Posted by ChemistB
LOL, that's what I was getting to but thought there must be something I'm not seeing here.
thanks for looking into it ChemistB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks