in our last Excel video we touched
briefly on excels logical if formula to
calculate if a bonus had been earned
if weekly sales is greater than X then
the bonus has been end and we use the
same formula to calculate the final pay
with and without the bonus the if
formula is really useful and there's a
lot more that it can do here's the basic
structure we apply a test if our test
passes and is true then Excel will do
one thing if it fails and it's false
Excel will do another to use if fully we
have a whole range of logical operators
they're called logical or boolean
operators because there can only be one
of two answers true or false you're
probably well familiar with the equals
operator Excel also uses the greater
than and the less than operator as well
as the greater or equal to or less than
or equal to and finally not equal to
operators let's look at an example using
the greater than operator if cell b3 is
greater than 100 print yes if not print
no the quotation marks are quite
important they tell Excel to print text
rather than to look for a cell called
yes or no it test is simple if cell b3
contains a number that is greater than
100 the test is passed and Excel will
print yes in the current cell if the
test fails then Excel will print no in
the current cell now let's try it out
using dates here's a simple test to see
if an invoice do 30 days after the
invoice date is overdue or not
the logic we need to construct is quite
straightforward if today is more than 30
days after date print overdue if not
don't print anything first we need a
column showing the invoice issue date
next we need the operator to get today's
date we'll look at working with dates in
depth in a later video but the formula
to get Excel to print today's date is
equals today open and close brackets and
if today's date is more than 30 days
after the invoice date then we want
Excel to print overdue so here's the
formula if open brackets today is
greater than the invoice date plus 30
print overdue if not don't print
anything and it works let's apply it to
the whole of our list job done eTop
Technology we're here to help
if you like these videos please
subscribe to our YouTube channel if you
found this video helpful check out some
of our more recent videos and if you're
looking for a new IT partner please
visit our website
