Okay. So, in Microsoft Excel you can use a function also. So, we can do something like this A SA is equal to maybe 4.6 me return I say, valueless one or else we return zero and we can do something like this. Then we can drag this all the way. So we know which one is 4.6. So 4.6 you can see is here.

So if this column, this is a seven cell here is 4.6 10 y'all gave us a one So, 111 So, this is the if statement in this cell. So in this cell, we can put $1 sign here. So that when we draw a, it will always be in this column A. Okay, so if I say I drag this let's say I do something like this equals sum E equal to some k equal to Sam. I may want to add $1 sign here. So, that row will not change.

So, when I read them, it'll be something like this. Okay, so if I want to drag this one, let's say somewhere here, he also gave me the same value. So so. So usually if I say we want to do are these dragging. So if we want to, let's say dragony for this variable here, so we will usually put $1 sign here, I found this a here, a we want to try the other way, we'll usually put $1 sign ID as a number here, I had a roll roll number here. So as I say, usually we do something like this and I Usually if we do not want to do something or these are dragging, we can put $1 sign for both column and row.

So for for this I will say this we can put $1 sign or this we can put $1 sign. Okay audience you can put $1 sign or this you can put $1 sign are these we can put $1 sign Okay Are these I can put $1 sign to put $1 sign okay these dollar signs I will say will be are very important for this are we Luca so that the table will not change when we do some dragging. So he will always be the same and then for here we can put $1 sign here So, okay so this is how we can do all these if statement and all these dollar signing this Microsoft Excel