Help with a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zemo - 30 Sep 2004 13:45 GMT

corpse_make_list={{[magic_ring];1;1;12.0603};{[stem];1;1;3.9799}}

This is the data in the cell, for a game. The last two numbers 12.0603 and
3.9799 are what I need to change, they vary throughout the column.
Is there a way i can make a formula for this to change each end number by a
certain amount, say 10X what it is now?

Thanks for any help, Im very new to Excel :D

Reply to this Message

Sanjay Valiyaveettil - 30 Sep 2004 15:48 GMT

Zemo,

This should show you how to do it:

Goto Cell A1 and type exactly this
="corpse_make_list={{[magic_ring];1;1;"&B1&"};
{[stem];1;1;"&C1&"}}"

Now in B1 put in 12.0603
and in C1 put in 3.9799

Now the cell A1 should show you the figures you want.

Now in Cells B2,B3 etc put in the values for the
magic_Ring and in C2,C3 etc put inthe values of the stem.

Put the cursor on A1 and copy the formula down to the
numbe of rows. (ctrl-c and ctr-v)

It will contain the cell values you want.

hit reply if you are having a problem. i do this all the
time.

sanjayva at yahoo dot com

>-----Original Message-----
>corpse_make_list={{[magic_ring];1;1;12.0603};{[stem];1;1;3.9799}}
[quoted text clipped - 7 lines]
>
>.

Reply to this Message

Zemo - 30 Sep 2004 16:11 GMT

Ok, the prob is, the data is already there, i just want to change it by 10x
the original amount

This is what the column looks like all the way down, it varies depending on
the creature

Column T
T1 corpse_make_list={{[magic_ring];1;1;12.0603};{[stem];1;1;3.9799}}
T2 corpse_make_list={{[charcoal];1;1;7.007};{[magic_ring];1;1;42.4667}}
T3 corpse_make_list={{[suede];1;1;6.4142};{[willow_staff_head];1;1;0.6872}}
T4
corpse_make_list={{[lesser_healing_potion];1;1;26.7647};{[suede];1;1;8.0294}}
T5corpse_make_list={{[lesser_healing_potion];1;1;34.2744};{[mage_earing];1;1;3.8036}}
T6 corpse_make_list={{[suede];1;1;12.2807};{[cotton_shoes];1;1;6.0695}}
T7
corpse_make_list={{[rp_sword_of_reflexion];1;1;2.0283};{[charcoal];1;1;27.5844}}

All I want to do, is change the existing numbers to 10X what it is now, so
this one
corpse_make_list={{[suede];1;1;12.2807};{[cotton_shoes];1;1;6.0695}}
would be
corpse_make_list={{[suede];1;1;122.807};{[cotton_shoes];1;1;60.695}}

There are many to change
i dont know enough about Excel to know if its possible to do with formula
instead of by hand
because there are 2000 of these hehe

> Zemo,
>
[quoted text clipped - 36 lines]
> >
> >.

Reply to this Message

Sanjay Valiyaveettil - 30 Sep 2004 17:24 GMT

okay here is what you do:

copy the values to a new sheet to the T column again.

Now select the entire column,
click on Data>Text to Columns
Choose Delimited radio button
click Next
Make sure only the semicolon box is checked uncheck all
the other boxes.
Click Finish.

Now you should have 8 columns from T to AA
In S1, put the figure of 10 or whatever multiplier
in AB1, put the following formula
=T1&";"&U1&";"&V1&";"&LEFT(W1,LEN(W1)-1)
*$S$1&"}"&";"&X1&";"&Y1&";"&Z1&";"&LEFT(AA1,LEN(AA1)-2)
*$S$1&"}}"

the only thing i have done here is to concatenate
everything back with seim-colons(and multiply the
numbers). you shouldbe able to customize this.

only thing to note is that i have anchored the multiplier
($S$1)so that you only have to put 10 in one place - in
case the multiplier also changes with every row just
specify the multiplier as S1 instead to $S$1 and put the
multiplier inthe S column.

when you are done, just copy the entire AB column and when
you paste it, use paste special and choose only values.

you should be all set.

When do i get to play the game? :)

regds
Sanjayva at yahoo dot com

>-----Original Message-----
>Ok, the prob is, the data is already there, i just want to change it by 10x
[quoted text clipped - 67 lines]
>>
>.

Reply to this Message

Zemo - 01 Oct 2004 12:05 GMT

Thhanks, was very helpful :D

> :)
>
[quoted text clipped - 123 lines]
> >>
> >.

Reply to this Message