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.

Share this great discussion with others via Reddit, Google+, Twitter, or Facebook