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

    24forChromium

    User Avatar

    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. jcsd
    Phys.org - latest science and technology news stories on Phys.org
  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/
     
    Borg, Oct 8, 2015
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Excel: Entering empty cells with function

  1. Plotting functions in Excel (Replies: 3)

  2. Generate a function on excel (Replies: 3)

  3. MS Excel Function (Replies: 3)

  4. Autocorrelation function in Excel (Replies: 1)

  5. Use Excel to find the similarity between functions. (Replies: 2)

Loading...