Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If Then Combining AND with OR Function

Status
Not open for further replies.
Kevsim

Kevsim

Instructor
Apr 18, 2000
385
AU
In a spreadsheet cell, I require to have an IF statement with both an AND statement and also an OR statement.
How do you combine an AND with an OR function.
I would appreciate your advise.

kevsim
 
Sort by date Sort by votes
Please, post in the Microsoft Office forum for formulas questions: Forum68
 
Upvote 0 Downvote

Did you look up the AND and OR functions in the help file?

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
foxup
  • Locked
  • Question
CDO TLS or SSL
Replies
1
Views
602
foxup
foxup
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
598
mintjulep
M
TheAceMan1
  • Locked
  • Question
Detect if Ribbon Minimized or Maximized 1
Replies
2
Views
728
TheAceMan1
TheAceMan1
sxschech
  • Locked
  • Question
For Each Loop works once then gives error 91 2
Replies
19
Views
1K
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top