00:00so now let's see one of the most commonly used formulas in microsoft excel and that is the if
00:10condition formula let's say for example if i were to go ahead and type in apple around over here on
00:17this particular cell then i want it to show the price of apple let's say for example um uh two
00:25dollars right here uh two dollars i'm just going to say two right here and i'm going to add in dollar
00:30right here as the value at the end and then if it says banana let's say for example then it's going
00:36to be let's say for example 0.8 right here 0.8 dollars so this is what i want to display so now
00:44for that i'm going to go around over here and add in the if condition so i'm just going to go around
00:49over here and give a title as item and i'm going to say price right here just like this let's just go
00:54ahead and bull them out as well so now to add in the if condition i'm going to press equals and i'm
01:00going to type in if and open up the bracket right here so the logical text right here is let's say
01:06for example this one so if a2 the value in a2 is equal to apple so right now we're taking a text
01:14input meaning i need to go ahead and add in a double inverted comma right here and type in the exact word
01:20if you're actually adding in a number only then you don't need to add in the double inverted comma
01:26right here so now uh this is what i want so if a2 is equal to apple then this is going to be two
01:33dollars right here otherwise let's say for example uh if it doesn't say apple let's say for example
01:39then i'm going to say 0.8 so whatever else i type it is going to be 0.8 right here so let's just go
01:46ahead and close and press enter and since it says apple it shows 2 but if i were to type something
01:51else it shows 0.8 so apple right here and let's just go around and say banana right here i can go
01:58ahead and click and drag out the formula as well and you see the 0.8 i can go around over here and
02:04select it and then i can go ahead and choose the dollar button right here and home under number and
02:11you see the exact price so if i were to go around and type in banana let's say for example it says
02:160.80 and if i were to type in apple it says two dollars just like this and this is simply how you
02:23can use the if condition so let's say now if i press one then it should show uh two dollars and
02:30everything else should be let's say for example uh everything else should be um 80 so for that over
02:38here i'm going to go around and type in one and press enter and since it says one right here you
02:43can see that it's two dollars but if i were to type in two or zero right here it's a and 80 cents so
02:49press two right here just like this or one and that is what you have and in the formula you can
02:55actually see that since it is not a text i'm not writing any inverted commas but around over here i can
03:01actually go ahead and add in text as output as well so i'm just going to say two dollars right here just
03:07like this two dollars right here just like this and everything else is let's say for example right
03:14here i'm going to say 80 cents right here just like this so this is what you have so one is two
03:20dollars and two is 80 cents so that is how you can go ahead and utilize if condition inside of
03:28microsoft excel so if you found this video useful be sure to hit the like button don't forget to share
03:34this out with your friends and family and for more contents like these do follow simple tutorials
Comments