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

  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


    User Avatar
    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.

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)