Microsoft Excel #06: Using “IF” in Formulas
September 6, 2009 - 1:13 am
More advanced formula uses including the “IF” statement. For example, “IF someone earned over $200 then charge them $20… otherwise charge them $40.” This is a very powerful tip.
Duration : 0:4:51
[youtube GCQErmN0eOI]
September 6th, 2009 at 1:13 am
Great info however …
Great info however even if I click on the HQ button it doesn’t change it at all.. and it’s still not only small but very blury. is there something the teacher can do when making the video to make it larger and clearer. There is another guy doing excel tutoring and his is clear and at times he zooms in a bit to make it easier to see.
Thanks for your help
September 6th, 2009 at 1:13 am
yes it would be …
yes it would be clear.
September 6th, 2009 at 1:13 am
Just click on the …
Just click on the HQ button. shows up clearly for me
September 6th, 2009 at 1:13 am
it would be a great …
it would be a great help if you can maximize it cause i can’t see it clearly,…
September 6th, 2009 at 1:13 am
Your tutorials are …
Thank you very much!
Your tutorials are really useful! Helped me a lot in my schoolwork!
September 6th, 2009 at 1:13 am
hq, i can see fine
hq, i can see fine
September 6th, 2009 at 1:13 am
caant c
caant c
September 6th, 2009 at 1:13 am
THANKS DUDEE
THANKS DUDEE
September 6th, 2009 at 1:13 am
bro i cant see …
bro i cant see nuthin clearly
September 6th, 2009 at 1:13 am
how come isang …
how come isang candle only
September 6th, 2009 at 1:13 am
Great clips! You …
Great clips! You can’t tell me the formula you use to make a cell pattern colour change when using an IF command can you?? Fingers crossed and thanks
September 6th, 2009 at 1:13 am
MY man, You did a …
MY man, You did a gr8 job. If I get a job today is thanks to You in a big way
Greeteings from Botswana
September 6th, 2009 at 1:13 am
try using the ” …
try using the “conditional format” under ‘format’ menu
September 6th, 2009 at 1:13 am
hehehehe all my …
hehehehe all my friends say im REALLY naughty and flirty. hehe *maybe* 3
September 6th, 2009 at 1:13 am
hey Ray, great …
hey Ray, great video.. a quick Q…how do i use the if function to return a value from dates ie. if i have data entries 6 months to 2 months ago (date column) how can i show how many are over lets say 3 months old….
September 6th, 2009 at 1:13 am
Hey how can I add …
Hey how can I add color, font, etc to a If statement.. Something like this..
=IF(A12>49,(italics+red color)”Not Available”,(cold+green font)”Available”
September 6th, 2009 at 1:13 am
I find it easier to …
I find it easier to go to paste function and do this. Because some times can’t remember the functions etc.
September 6th, 2009 at 1:13 am
Hello Daniel. …
o Daniel. Thank you. One method to solving your problem is the use of an advanced filter. I’ve posted a video demonstrating this technique on my page. I hope it helps. Ray
September 6th, 2009 at 1:13 am
i am new to excell …
i am new to excell at all, looks like you are a pro on this, what i am trying to do if excell is capable of doing this plan of mine, example is Sheet 1, i typed a name JOHN , then there is a scoring chart. 20 points to make it. so i put all the point from different activities, then total of 25, on sheet 2, this is all people that made 20 pts and above. how can i make what if total 20 pts above then the name will be auto listed to sheet 2. help pls. thanks man
September 6th, 2009 at 1:13 am
jpodthebro, I’m …
jpodthebro, I’m uming that you will place the formula in the column being checked for > zero, say C22 in your example, and that your SUM criteria is only for the current column and that you want the other row 3 numbers averaged regardless of the sum of those columns. The formula: =IF(SUM(C4:C14)>0,SUM($C$3:$F$3)/COUNT($C$3:$F$3),(SUM($C$3:$F$3)-C3)/(COUNT($C$3:$F$3)-1)) Regards.
Freetutorials, nice job with the lessons. I’m new to Youtube, so I hope responding to your posters is ok. Ray
September 6th, 2009 at 1:13 am
Ray I just …
Ray I just remembered and Yes I did want to check columns D, E, and F similarly. That is the reason I was having trouble. I need those columns checked and cells included/ excluded in the average based on the value checked for each. Is that possible?
September 6th, 2009 at 1:13 am
Thanks for the info …
Thanks for the info Ray. This could potentially really help me out but I’ll have to try it at work tomorrow. So this formula should take a cell out of the average if the same column has a total of 0?
September 6th, 2009 at 1:13 am
hello jpodthebro, I …
o jpodthebro, I was doing some research to learn if there was a need for a tutorial on Excel formulas when I came across your question. The formula for your example is: =IF(SUM(C3:C14)>0,AVERAGE(C3:F3),AVERAGE(D3:F3)) The formula would be more complicated if you wanted to also check columns D,E, and F similarly, but it can be done. Enjoy.
September 6th, 2009 at 1:13 am
Adding “&fmt=18″ at …
Adding “&fmt=18″ at the end of the YT URL helped the clarity of the video……that was so cool…Thanks!!
September 6th, 2009 at 1:13 am
Yea but heres a …
Yea but heres a hard question. How do you use multiple formula in the same IF statement. Like if you want an average of cells ‘C3 D3 E3 F3′ but only IF the value in lets say C3 to C14 have a total greater than zero while keeping in mind that you still want the average of cells ‘ D3 E3 F3′ just excluding C3 IF it has a total of 0 in C3-C14? Thats a hard one eh? I’ve been trying to figure it out for a while now but its really hard.