answersLogoWhite

0


Best Answer

The OR function contains at least two logical statements. If at least one is true, then it will return a TRUE result. If not, it returns a FALSE result.

=OR(10>2, 3>5)

Obviously 10 is greater than 2, so the above function will give a TRUE result. The OR function is usually used in conjunction with an IF function, to allow a particular action to be taken based on the result of the OR function. The OR function will be in the condition part of the IF function, which is the first part.

User Avatar

Wiki User

8y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

13y ago

EXAMPLE:

=IF(OR(AND(A1>100,B1="Red"),AND(A1<100,C1="Monday")),"Yes","Oops!")

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you write an OR statement in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you put an if statement in excel?

=IF(statement,true,false)


How do you write urdu in excel?

a


How does write statement differ from writeln statement?

I think you mean written statement. What you are asking about write statement you are confusing with written statement, the same with write in statement. A written statement is simply putting your words, or your version of events in writing.


Which format does a statement display in?

PDF file


What format does us bank statement display in?

excel spread sheet


Can you write 111 in excel cell?

Yes.


Ho do you write a squeare in computer?

in excel


How do you write a good statement to get u into a university?

how to write a statement to the University of Art and Culture


When you start the Excel program a new what displays?

That is not a question but the statement is correct. It opens a workbook and you see a worksheet in it that you can start working in.


How do you write a declarative?

write a statement or a question sentence


How do you write a statement in French?

'A statement' in French is 'Une d&eacute;claration'


Can you use C plus plus with Excel spreadsheets?

This question is irrelative because C++ is a language and Excel is a software. The thing is that we can't use C++ with Excel, but we can write a program like excel in C++.