Increasing cell value based on random test

Hi

I am creating my first bit of excel code to help me with some bookkeeping and so far so good. However, I have a question regarding the calculation of a cell's own value which I would appreciate some help with.

For example, let's say I have a hand entered value in column A1 (for eg "11") which I want to increase by 1 point (to 12) on the outcome of a random event. In this instance, the value will increase by 1 if a random roll from 1 to 20 is higher than the current value, so on any roll of 12 or more. I know how to create a random number and I'm fairly sure of the logic to make the calculation, but I don't know how you make a cell "look" at itself and increment it's own data based on the logic outcome.

Back in the mists of time using Amiga basic I'd do something like IF (random number)>A1 THEN A1=A1+1 but this is not an Amiga

thanks
Andy

Thanks for the reply.

Can you clarify a bit? When you say A1=11 B1 = etc etc are you saying I would need to spread the logic over three separate cells? Is it not possible to house all of the logic in A1?

Got it, this will do what you want by running the macro. That was so much easier than I remembered, just had to refresh my mind

Please Login or Register  to view this content.

Thank you for taking the time out to help me with this.

I have to say I don't understand a single line of that code so I am just going to cut and paste it as it.

Would you mind just telling me how I go about running a VBA script in a cell or could you point me to a faq that shows how it's done.

many thanks again

Originally Posted by AndyGW

Thank you for taking the time out to help me with this.

I have to say I don't understand a single line of that code so I am just going to cut and paste it as it.

Would you mind just telling me how I go about running a VBA script in a cell or could you point me to a faq that shows how it's done.

many thanks again

Easiest way.... press ALT + F11 which will open the VB editor. Under Insert, click module and paste that code. Then you can press ALT + F8 and select the macro and press run and you are done.

Can see here for the basics of macros.

http://www.excel-vba.com/excel-vba-s...-beginners.htm

Did you want to only do one cell at a time? Noticed you mentioned it being by cell... what I posted will process for all values in column A. If you want it to just do one cell at a time based on you selected cell this will work:

Please Login or Register  to view this content.

If you want to see what it is doing, this will tell you what the results were and what it did and will let you verify I entered this as you intended:

Please Login or Register  to view this content.