#1   Report Post  
Old September 8th 05, 08:40 PM
Matt Montagliano
 
Posts: n/a
Default 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   Report Post  
Old September 8th 05, 08:47 PM
JE McGimpsey
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Do I need a sumif or sum of a vlookup formula? PeterB Excel Worksheet Functions 0 June 1st 05 12:23 PM
IF Statement nightmare eugenevr Excel Discussion (Misc queries) 6 May 18th 05 01:09 PM
IF Statement Brent New Users to Excel 3 April 29th 05 04:24 PM
How to calculate a sum as one outcome of an IF statement barb in NC Excel Worksheet Functions 2 March 31st 05 08:01 PM
What statement to use? Paul Excel Worksheet Functions 6 February 13th 05 06:23 PM


All times are GMT +1. The time now is 12:26 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017