0
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
The OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoThe OR function is used to choose between one option and another where one or other needs to be true. So the following function uses an IF and an OR to show a good message if the Sales are over 1000 or if the Profit is over 10000. Only one or other needs to be true for the positive message to be shown.
=IF(OR(Sales>1000,Profit>10000),"We had a good month","Bad month")
Add your answer:
Earn +20 pts
What is the step function of Microsoft Excel?
There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.
Can you use Sum Function in school?
If you use Excel in school, then, yes, you can use the SUM function.
To add numeric enteries quick in excel use the function?
Use the Sum function.
How do you use the all function in Excel?
you can get help in the Microsoft excel itself by pressing F1 key.
Which Excel function would you use when you want to determine a monthly loan payment?
The PMT function.
Which function can be used to check whether the value is numeric or not?
In Excel you can use the ISNUMBER() function.
What is quartile Excel function?
There is no function to create a quartile in Excel. A quartile is a 25% division of a statistical collection of data. You can use Excel to create a chart to let you observe the quartiles of the data.
Is total and sum the same thing in Excel?
SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.
How do you do standard deviation on Microsoft Excel?
Use the STDEV() function.
Can you enter a function in Excel using autocomplete?
You can use the clipboard in Excel. It is a facility as opposed to a traditional function, like the SUM function or AVERAGE or MAX and other functions that are built in to Excel.
What does Excel use to separate multiple arguments in a function?
Commas are used to separate arguments in Excel functions.
How do you generate random numbers in Excel?
You can use the RAND function or the RANDBETWEEN function.
