Author |
Topic ![Next Topic Next Topic](icon_go_right.gif) |
|
Fanning
UK
10 Posts |
Posted - 03/18/2009 : 05:50:26 AM
|
Hi
I need to perform antilogarithm function of 2 on my data. For example, 0,1,2,3,4 will be converted into 1, 2, 4, 8 and 16 respectively. At the moment, I am doing them one by one by calculator. Is it possible anyone write a script for me please? because this is so out of my depth!
Thank you very much in adavance.
Fanning |
|
chansen14
USA
Posts |
Posted - 03/18/2009 : 08:10:18 AM
|
If your data are in column A, you could just use the "Set Column Values..." command (Column menu item) to populate column B with what you want.
2^col(A)
should work.
Chris
|
Edited by - chansen14 on 03/18/2009 08:13:48 AM |
![Go to Top of Page Go to Top of Page](icon_go_up.gif) |
|
Fanning
UK
10 Posts |
Posted - 03/18/2009 : 08:23:57 AM
|
Hmm, so simple. Why did not I think like that before?!
Thanks a lot, Chris. |
![Go to Top of Page Go to Top of Page](icon_go_up.gif) |
|
|
Topic ![Next Topic Next Topic](icon_go_right.gif) |
|
|
|