Question: EXCEL FORMULA FOR MISSING DATA Hello I have a homework question that ask me How many have missing emails AND phone, email OR phone

EXCEL FORMULA FOR MISSING DATA

Hello I have a homework question that ask me " How many have missing emails AND phone, email OR phone for contact information". I wondering to solve this if you're supposed to use is blank Im confused on how to bring about the formula to solve this on excel. Here is what I thought the formula would be : =IF(ISBLANK(AND(RANGE 1, RANGE 2) but Im not sure how I would continue it or if that's even the correct formula.

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!

This text was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License without attribution as requested by the work's original creator or licensee. 1...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

This assignment requires you to read an article on how to avoid group conflict, and make sure that all members contribute to the group assignment. While it is a group assignment, every member should...

Hello, This is the Fina 210 Course about Real estate. Could you help me to solve this problem and show me a solution? because i want to know how to solve this type of question in exam. Thank you! ps:...

Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...

i need help finding a recommendation on what the company (Paycom) should do in this situation. the major question i need answers to are 1.rethink a criteria for defining a high priority potential...

Waris.Ge Applicator pendent Frecuente Applicator Tracking at Cet hom ws.com walmart K Registration | Kood Vretta Mall - Asha Venkat ..Workday-Shopo Overview Tange Financial Planning and Economies...

Read and analyze the following document developed for an organization and in ONE full page discuss how this process may help an organization identify, recruit, and retain top talent. STAFF...

Module 9 Assignment: TOC Answer all the questions and submit your answer report to Module 9 Assignment in Dropbox by the deadline . The report should be typed, single spaced, in one MS Word file. You...

7.0: Organizational Strategy Overview (one paragraph describing the following charts) 7.1:CurrentOrganizationalStructure(chart)...

What is the most important contract you will need to run your business? Describe any additional contracts you have or plan to secure.

Eutsler forged his brother Richards indorsement on certified checks and cashed them at First National Bank. When Richard sought to recover the funds from the bank, the bank stated that it would press...

James agrees to pay 2m for a controlling interest in Sapphire plc providing the company transfers 3m deposited with its present bankers to Emerald Bank from which James has arranged to borrow 2m....

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Explain why the following paragraph would be ineffective as the opening paragraph of a letter to Dawn trying to persuade her to take on the reponsibility of membership committee chair for the...

Write a persuasive article for your school newspaper convincing students to participate in the upcoming election of officers for the Associated Student Government. Provide appropriate details in the...

What organizational plan is most effective for persuasive messages? What are the four basic elements of this plan? (Objective 3)