One way:


=IF(AND(G1F1,G11),"?","")

In article ,
"Matt Montagliano" wrote:

I want to create and apply an if statement to my worksheet. I want the if
statement to only show the data that equals the criteria in the if
statement. the if statement looks something like If column g is less than
column f and column g is greater than 1 than ? I dont knwo how to go about
implementing thsi on my worksheet and how to display the data.