1. Oct 8, 2015 #1

   24forChromium

   

   How can I set up a function with an if command such that it only copies values greater than zero from another column while leave the rest of the cells empty (not zero)?

    

   24forChromium, Oct 8, 2015
2. 
   Phys.org - latest science and technology news stories on Phys.org

   • • Researchers create one of the smallest nanoparticle stabilized nanoemulsions with new technique
   • • Detecting metabolites at close range
   • • Research team uncovers lost images from the 19th century
3. Oct 8, 2015 #2

   Borg

   

   Science Advisor

   Gold Member

   2017 Award

   Use an if statement like this. To copy the value of cell A1, use this in the cell that you want it copied to.
   =IF(A1>0,A1,"")
   
   http://www.exceltrick.com/formulas_macros/excel-if-statement/

    

   Borg, Oct 8, 2015

• Log in with Facebook
• Log in with Twitter

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in