Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel: Entering empty cells with function

Tags:
  1. Oct 8, 2015 #1
    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)?
     
  2. jcsd
  3. Oct 8, 2015 #2

    Borg

    User Avatar
    Gold Member

    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/
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Excel: Entering empty cells with function
  1. MS Excel Function (Replies: 3)

Loading...