Let's imagine I have two sets of things:
Water bottles
Coke bottles
And in my excel I put my ratio of water bottles to coke bottles as lets say 2:3.
Now lets say in the water bottles say I enter 50. I want excel to automatically calculate how many coke bottles I will have based on my ratio 2:3.
If anybody can help with this? Perhaps provide an example worksheet.
Thanks
Is there a reason you need VBA for this? It can be done easily with a formula. For example:
In cell A1, type Ratio.
Format cell A2 as text and type 2:3 into it.
In cell B1, type Coke.
In cell B2, type 50.
In cell C1, type Water.
In cell C2, insert this formula:
Does this help?
Please Login or Register to view this content.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Can you kindly provide a quick worksheet so I can visualise it?
Oh and I thought VBA may be needed to write the ratio. Didn't know it could be done this way
Please see here:
Hi
Assuming you have the text "2:3" in A1, (and please note that if you just enter 2:3 in A1 it will default to a time value and this will not work) and 50 in B1 then the number if coke bottles is
Formula:
Please Login or Register to view this content.
It would be simpler of you entered the ratio as 2 numbers in separate cells, e.g in A1 & B1 enter 2 & 3, and 50 in C1. Then the calculation is
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks a lotAnd what does LEFT imply?
If you have the formula =left(A1,1), then it will return whatever is leftmost in the cell, so if the cell contains 2:3, it will return 2. If you change the formula to =left(A1,2), then it will return 2: (i.e. the first two characters or numerals that are leftmost in the cell). Hope this helps!
And the question you didn't ask, what's the Find for.
All is OK and simple if your ratio is always two single digits, e.g. 2:3, but if the ratio was say 25:35 then you'd need the two left and two right characters. That's what the Find does. In other words it generalises the solution so that you can have as many digits as you want without needing to change the formula. e.g 123:45
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks