Log in

Excel: =IF(OR - fuzzygruf's blog

> Recent Entries
> Archive
> Friends
> Profile
> Homepage

LJ Update
LJ Recent Comments
Search LJ FAQs
Edit LJ userpics
Manage filters
LJ collage
Edit LJ links
LJ guests and statistics
upload to scrapbook
LJ Stats
LJ portal

August 18th, 2014

Previous Entry Share Next Entry
03:39 pm, August 18th - Excel: =IF(OR

By itself, the OR function has limited usefulness, but combining it with the IF function can be helpful.

=IF(OR(B1>100,B2>100,B3>100),”Over Budget”,”Acceptable”)

Assuming this function is located in cell C1, if any of these three cells (B1,B2, or B3) contains a value greater than 100, the IF function will show the statement Over Budget in cell C1. If all three cells have numbers less than or equal to 100, the IF function shows the statement Acceptable in cell C1.

Taken from http://spreadsheets.about.com/od/excelfunctions/qt/or_function.htm


(Leave a comment)

> Go to Top