Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sql All In One For Dummies 7 Books In One

Authors: Allen G Taylor ,Richard Blum

4th Edition

1394242298, 978-1394242290

More Books

Students also viewed these Databases questions

Question

The number of new ideas that emerge

Answered: 1 week ago