Question: I am trying to use an If / Or function in Excel but keep getting an error. = IF ( OR ( A 2 =

I am trying to use an If/Or function in Excel but keep getting an error.
=IF(OR(A2=1, A2=2) "has internet", "no internet")
Any idea what I'm doing wrong? I'm trying to say if column A has a 1 or a 2 then "has internet" otherwise "no internet".

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

I'm trying to find out how to come up with this formula in Microsoft Excel . I keep getting error messages so I'm doing something wrong in the =IF function . In cell F29, use an IF function to...

Q:

Trying to use the decision tree function in Excel QM and receive a 424 error. I am not sure what to place for title and sheet name? How do I utilize the decision tree function in Excel QM?

Q:

I need to find the IRR of this table by using the function in excel. I keep getting an error. 0 1 2 3 4 5 20xx 20xx 20xx 20xx 20xx 20xx Investment Outlays at Time Zero: Equipment or other investment...

Q:

Breakeven cash inflows and risk Blair Gases and Chemicals is a supplier of highly purified gases to semiconductor manufacturers. A large chip producer has asked Blair to build a new gas production...

Q:

Breakeven cash inflows and risk Blair Gases and Chemicals is a supplier of highly purified gases to semiconductor manufacturers. A large chip producer has asked Blair to build a new gas production...

Q:

can you show me how to exaclty input the PV in excel i keep getting error message. pv layout what i need help filling in since only a pmt and I F G H Hint: See formula 6-5 on page 173 a. A $300...

Q:

Mr. Woods is valuing an investment that pays him $27,000 per year for the first ten years, $35,000 per year for the next ten years, and $48,000 per year forever; (all payments are at the end of each...

Q:

PLEASE ONLY SHOW ON EXCEL, I can do by hand. Calculate the standard deviation of returns for each stock and for the portfolio. When I use the standard deviation function on Excel, I'm not getting the...

Q:

Excel programming: Option pricing with a six -step binomial tree All tables and any attachments needed are attached as screenshots. I have made an excel spreadsheet for the test prep question but...

Q:

Excel programming: Option pricing with a six -step binomial tree There are no personal links in this question, I have attached screenshots of the excel set up but does not need to look exactly like...

Q:

10 Network classified according to transfer media to: Select one: O a. LAN out of O b. Wired communication and wireless communication question O c. WAN O d. LAN and WAN

Q:

Since opening in 2012, Akron Aviation has built light aircraft engines and has gained a reputation for reliable and quality products. Factory overhead is applied to production using direct labor...

Q:

Why do we close doors during a RACE response? Question 1 0 Select one: a . To contain the fire separations b . To contain the smoke c . To contain the oxygen d . To contain the occupants

Q:

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

Q:

Do you think it is important for Carter Cleaning Centres to have aformal grievance process? Why or why not? On visiting one of the cleaning locations, Jennifer was surprised when she was approached...

Q:

Should a disciplinary system be established at Carter Cleaning Centres? Being in the laundering business, the Carters feel strongly about their restrictions on employee smoking, eating, and drinking...

Q:

How would you have reacted if you had walked into the store to witness your employees having their lunch in this manner? Being in the laundering business, the Carters feel strongly about their...