| 
        
          | 
              
                | Author |  Topic  |           |  
                | Fanning
 
                UK10 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
 
                USAPosts
 | 
                    
                      |  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
 |  
                      |  |  |  
                | Fanning
 
                UK10 Posts
 | 
                    
                      |  Posted - 03/18/2009 :  08:23:57 AM           
 |  
                      | Hmm, so simple. Why did not I think like that before?! 
 Thanks a lot, Chris.
 |  
                      |  |  |  
                |  |  Topic  |           |  |  |