Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > Excel IF statements

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel IF statements

Reply to Message Icon

Name: jealap
Date: August 17, 2009 at 15:56:13 Pacific
OS: Windows XP Home SP3
CPU/Ram: 150 gb of Ram and a Athlon(tm) XP2400+ 2.00 Ghz processor
Product: Microsoft Microsoft office excel 2007 - license
Subcategory: General
Comment:

How do I write an IF statement that will compare two values and return the value that is the lowest?



Sponsored Link
Ads by Google

Response Number 1
Name: Mike (by mmcconaghy)
Date: August 17, 2009 at 16:12:40 Pacific
Reply:

The syntax of an IF statement is:

=IF(Condition,ActionIfTrue,ActionIfFalse)

So to compare two values and return the value that is the lowest? you would place somthing like:

=IF(A1<B1,A1,B1)

In cell C1

MIKE

http://www.skeptic.com/


0

Response Number 2
Name: jealap
Date: August 17, 2009 at 16:19:45 Pacific
Reply:

Thanks so much Mike


0

Response Number 3
Name: Mike (by mmcconaghy)
Date: August 17, 2009 at 18:02:00 Pacific
Reply:

Glad I could help.

MIKE

http://www.skeptic.com/


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: Excel IF statements
Microsoft Excel IF Statement www.computing.net/answers/office/microsoft-excel-if-statement/4444.html

Excel IF Statement Help Needed www.computing.net/answers/office/excel-if-statement-help-needed/7417.html

Excel IF statements and conditional www.computing.net/answers/office/excel-if-statements-and-conditional/7035.html