We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
|
By:
=formula*(1+ROW(A1)*0.1)
|
|
By:
Thanks for your help bushy
I've tried it but unfortunately because I have several 'lists' of values within the same workbook and I would want the top cell of each list to be 1, it doesn't quite fit the bill but if I introduce another column of values alongside each list, I think it should be workable |
|
By:
Possibly set up a table on another worksheet with your multiplying factors and then do a vlookup to draw them in as appropriate throughout your spreadsheet?
|
|
By:
Yes that sounds like the way to do it Dave
now that i am reconciled to actually typing in the factors for each cell |
|
By:
create another worksheet with multiplication factor and use that in your formula.. if it is a simple series like increment of 10 should be fairly easy to do....
|
|
By:
Is there an echo in here?
|
|
By:
Hi, I could not work it out myself so I asked the question on mr excel and got an answer.
The formula given only now needs to have the multiplier of A1* whatever tacked on to =Topcell As ~ =Topcell*2 (if A1 was multiplied by 2) http://www.mrexcel.com/forum/showthread.php?t=582427 Explains what to do. |
|
By:
thanks very much for your time and effort compound magic
|