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
From:
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
User
Account name:
Password:
If you don't have an account you can create one now.
Subject:
HTML doesn't work in the subject.

Message:

 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

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:47 am
Powered by Dreamwidth Studios