nest
## Nested IF function in Google Spreadsheets

all right let's check out how a

nested-if function works now if you have

already not seen how a basic if function

works I highly encourage you to check

out that video and the tutorial of the

if function first we have both an if

introduction and also an example of the

if statement on our website here wwr

sheet solving calm now how does the

nested-if function work okay we're going

to take a look at an example here and we

will show you how why this formula here

which is a nested function y that has to

be the case okay let's start with the

inside if function first which states if

H 2 is less than 0 please return why

otherwise return a blank

ok let's explain that right now what

that inside if statement is saying is if

the days left to complete which as you

can see is negative 32 days how does

that come to be while the due date was

October 31st and today is December 2nd

so the difference between the two is 32

days if you are late by 32 days in other

words your the days left to complete is

negative below zero then by default we

would say that this task is due or past

due if it's positive then it is not due

or past you and we would like to specify

that by keeping that cell blank and that

we can represent by using two quotation

marks so you'll see that when we click

enter the answer will be or the result

rather will be yes right because we do

see that H 2 cell H 2 is less than 0 so

it should return the second argument

which is why perfect

so just as we expected this is how that

cell was returned but we have a second

criteria and what is that that criteria

is whether or not you did the task so if

you did that task if this is a yes at

that point we shouldn't say it's due or

past due because you've already done it

okay so in that case we need to specify

another if statement and this is where

the nested if statement is born so

preceding this criteria we should say

that if the task done is yes if it's

done then you might as well just keep

that cell blank because we don't need to

flag whether that task is due or past

you you've already done it so now take a

look at how this formula is set up if I

- which is your test done is Y is done

then return a blank otherwise otherwise

if that these left a complete is

negative please return a yes it is due

or past due at this point if you click

enter we'll add in our last ending

parenthesis and click enter you'll

notice that it still says yes because we

haven't done the task yet but what if we

now enter in a Y because we have done

the task at this point that cell returns

a blank exactly as we had stated it to

be okay so here you go you'll see in

this these cells the formula has been

copied downward you have the nested and

if function that exists because we do

have the two criteria impacting that

result great thank you for listening and

we'll see you next time

how to do nested if statements in google sheets

how to write multiple if statements in google sheets

nested if formula google sheets

how to make if statements in google sheets

how to use multiple if statements in google sheets

using if formula in google sheets