• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 95
  • Last Modified:

Excel Help - Populating an IF Statement down the sheet

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?
0
RavenTim
Asked:
RavenTim
  • 2
1 Solution
 
Randy PooleCommented:
Use direct reference
[=IF(G12>0,$A$8,"")]
0
 
Randy PooleCommented:
I may have it backwords, not sure if you wanted to maintain A8 or G12 if G12 then
[=IF($G$12>0,A8,"")]
0
 
RavenTimAuthor Commented:
That works!  Thanks Randy!!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now