Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If statement
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement nightmare | Excel Discussion (Misc queries) | |||
IF Statement | New Users to Excel | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions |