How to Ignore Formula / Not Calculate If Cell is Blank in Excel

↔️ ↕️


hi it's chester at blue pecan computer


and in this video we're going to look at

how to perform a formula

only when the cell is not blank

so here's my scenario i've got

a record of the number of calls a call


and then the number of calls that were


and what i want to do is to find out

what percentage of calls

were dropped by each salesperson

and there's two ways you can do this in

excel you can evaluate whether there's

an empty text string

or you can use the is blank function but

there are important differences

between the two methods and that's what

i want to explore

in this video tutorial so first of all

Related queries:

how to not include blank cells in excel formula
how to exclude a cell in excel formula
how to add a cell in excel formula
how do i exclude certain cells from a formula in excel
how to exclude cells in excel
how to exclude cells from calculation in excel