fuzzygruf: (smiley)
[personal profile] fuzzygruf

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

Profile

fuzzygruf: (Default)
fuzzygruf

April 2017

S M T W T F S
      1
2345678
9 101112131415
16171819202122
23242526272829
30      

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 23rd, 2017 08:34 am
Powered by Dreamwidth Studios