All language subtitles for 6. Solution to Logical Formulas Case Study

In this video we will solve the logical formulas.

Case study the first thing we will do.

See if the store achieved its sales target for quarter 1.

The sales target for quarter 1 is given in cell 5.

Saturday 5 has sales for quarter 1 as calculated in the MAC formulas.

Case study in Cell L5.

We will use if function to compare actual cells with Target to see if the restorative is quarterly sales

target for quarter one.

Select cell a on formulas tab select logical and select if from the drop down list

in the logical test box let us enter defined greater than K file we are dealing here that Dave defines

cell is greater than K 5.

Then it the value which is entered in value.

If Group box because Saturday 5 has actual sales and K 5 as target this formula is going to return the

value in value to box.

If sales target is achieved let us enter.

Target achieved in value is to box in the value a false box.

Let us enter target not achieved the formula Luton target not achieved.

If actual sale is less than diet coke it so level 5 now displaced target achieve because quarterly sale

is more than that target.

You can also see the special formatting for sale site.

This is done to highlight important sales or data in your work sheet.

Let us copy sell L5 and paste in a line in 13 and 17 to see if sales target for other quarters were

met.

You can now see that in quarter one and quarter to target positive but in quarter three and quarter

for target was not active.

Let us use the same formula to receive the annual sales target positive.

You can now see that I am not a sales target was a team and no it is more than the annual target.

Next we will see if sales target for all four quarters was a team.

We will do that in sell date twenty one very loose and a logical operator to see if this target for

all four quarters Verity intel and

that function takes multiple logical operations as its argument.

Let us play the first argument which is to received the quarter 1 since target was the team they've

already found that out in still L5.

So let us put out a five equal to target achieved.

Here we are killing Excel to see if the value of L5 is targeted t really picked the same exercise for

all the full quarters in line 13 and 17 since the formula is entered.

Press enter because for two quarters the sales target was not a team of the celebrate 21 returns false

meaning that condition that all four cells which measure target achievement are not seeing target T.

Let us see if Target for at least one quarter was a team select selling game 22.

We will use the order function to see if sales target for at least one quarter was achieved.

Entered on and provide logical operations just like we did for the day 21 so with the 0 5 equal to target

the team.

So what we are telling here is Detective level 5 is equal to target.

Let us do this for the remaining three quarters for sale and line 13 and 17.

That formula is ready Chris and don't and it equates to group because it is an all operator.

If any one of the conditions in the function evaluate to True it returns true.

And you can see at least two quarters we have target achieved so far this who operations logical operations

they are true and therefore the formula returns grew.