Excel Help - Populating an IF Statement down the sheet

Posted on 2014-07-16
Last Modified: 2014-07-16
I'm working in an excel spreadsheet using an IF statement [=IF(G12>0,A8,"")] and I'm dragging the statement down the page.  I want the first part (G12) to fill, but the 2nd part (A8) to copy.   Anybody know a way to accomplish this?
Question by:RavenTim
    LVL 21

    Accepted Solution

    Use direct reference
    LVL 21

    Expert Comment

    by:Randy Poole
    I may have it backwords, not sure if you wanted to maintain A8 or G12 if G12 then

    Author Closing Comment

    That works!  Thanks Randy!!

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
    Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
    Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now