How to nest if statements in google sheets
Nested IF function in Google Spreadsheets
Timecodes:
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
Related queries:
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
