Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples

[@tamimsajid]

I am an accountant, it will really help me a lot in my daily accounting calculations. I am really a great admirer of your beautiful videos, they are not less than a treasure for all of us. Thanks and regards.

[@excelisfun]

You are so welcome! Thank you for these very kind words: "not less than a treasure". Tell all your friends and collogues so even more of us can have fun with Excel! Thank for your support, Tamim!!!

[@stefanopalliggiano6596]

Just in case anyone was wondering how to extract the product name instead of the state abbreviation or the 6-digit numeric product code at 24:01 : this is harder to do, because the number of characters depends on the name of the product (eg. Aspen has 5 characters, Carlota has 7 and so on). After playing around with the formula, I found that one way to do it is to use the LEN function, which returns the number of characters of a string, combined with the MID function, which extracts a specified number of characters starting from a specified n-th character. The full formula is MID(B96,7,LEN(B96)-10). The "-10" is the overall number of characters that make up the state abbreviation, plus comma and space, and the numeric product code.

[@suryaprabakaran6507]

Thanks for doing the hard work @stefano

[@practicemail3227]

thanks a lot.

[@wagdyziada4503]

Easy, smooth jumping from 1 to 12, as usual you are EXCEL MASTER.

[@excelisfun]

Glad you like the videos !! Thanks for your continued support : )

[@dudundutta1165]

As a beginner, this video really helped me to know how excel works. A very very big thank you for creating this content! I really enjoy all your videos

[@excelisfun]

A very big you are welcome, dudun!!!!

[@sharonhanany3373]

I love this teacher's enthusiasm. When you start to properly learn Excel, it really is amazing.

[@excelisfun]

You are 100% correct when you say: When you start to properly learn Excel, it really is amazing. : )

[@jamesmyrthong6112]

You are a Great Teacher Mike👍👍. I never skipped your tutorials. It's one of the BEST. Thank You so much.

[@excelisfun]

You are welcome, James!!!!

[@TurboTeen29]

It's absolutely fun doing all these questions

[@SK-bv6yd]

You're such an excellent teacher, and I love "homework"!Thank you so much!

[@excelisfun]

You are welcome so much!!!!

[@sonialorenzo9223]

This is the best overview of formulas I have come across. I love it.

[@excelisfun]

Glad it helps !!! Thanks for the support with your comment, Thumbs Up and Sub : )

[@MonirulIslam-zj3ve]

Sir, Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. Thanks a lot to keep love and patience in your teaching field.

[@excelisfun]

You are welcome a lot!!!!

[@hazemali382]

you are the only one in whole world can I not only understand but also love Excel

[@excelisfun]

I am so happy to hear that, Hazem Ali!!!! I love Excel too and so that is why I post the free Excel Education for the world : ) Thank you for your support on each video.

[@hazemali382]

@@excelisfun I need your help may you type your mail would you please :)

[@ZEN2530]

The way you modulate your voice during the lectures makes the entire thing awesome..You are doing a great service to your viewers!!The coolest part about your videos is that;the more I watch them,the more I get interested to learn something newer..... Thanks man and god bless u!

[@excelisfun]

You are welcome a lot, ZENITH!!!! Thank you for your support on each video with your comments, Thumbs ups and a Sub : )

[@mostafaahmedzein450]

Thank you for being such an inspiring teacher, I'll keep commenting and Thumbs Up for each single video I watch! Keep up the good work... really appreciated

[@excelisfun]

Thanks, Mostafa!!!!

[@michaelmurray7472]

Thanks for taking the time to do these videos. Once i have finished the basic 1-24 videos. Have you got another series you would recommend? Your a life saver as i haven't touched excel sincr secondry school. Your a brilliant teacher enthusiastic and you go through ever really slowly

[@excelisfun]

What version of Excel do you have? Before Microsoft 365, this is the next class is: kzbin.info/aero/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw Microsoft 365, then this class: kzbin.info/aero/PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW

[@michaelmurray7472]

@@excelisfun Microsoft 365. Brill thanks for the help. Your a star :)

[@akhtaruzzamanjoy8524]

You are the best teacher ever!!!

[@omse96]

it s very professional tutorial you really spend a lot of time for it thank you very much . LOT OF RESPECT

[@excelisfun]

You are welcome a lot!!! Thanks for the RESPECT with your comments and thumbs ups, Sta : ) : )

[@northshoreunitarians6417]

I am so glad you taught me the Join function (using the ampersand) years ago at HCC. I do that ALL THE TIME at work. Such a handy trick!

[@excelisfun]

Yes!!! I love to hear that. The Ampersand is very handy. Now we have new functions like: TEXTJOIN too!!!

[@northshoreunitarians6417]

Oops! Used the wrong word there. I should have said Join OPERATOR (not Join FUNCTION).

[@excelisfun]

@@northshoreunitarians6417 Good catch! & is an operator : ) : ) : ) : )

[@hrprk5507]

I really like the excercises in this video. I was away for 2 weeks, and coming back I needed a refresher. Thanks so much once again.

[@excelisfun]

You are welcome so much, Hr Prk!!!

[@AbhishekSingh-ju6tq]

Why you r giving such precious knowlegde for free i am amazed to see that some people in this world give free knowlegde thankyou sir.

[@excelisfun]

It is my duty is to try and make the world a better place. I try to do this by providing free education here at KZbin!!! You are welcome, Abhishek!! You can pay me with a comment and thumbs up on each video that you watch, your Subscription and tell all your friends and colleagues : )

[@AbhishekSingh-ju6tq]

@@excelisfun you are amazing person thankyu

[@Brainz2b1]

Many thanks, Mike. God bless you.

[@excelisfun]

You are welcome, Emmanuel!!!

[@nawazmd121]

Good Job, Mike. We are blessed with your tutorials.

[@excelisfun]

You are welcome, Nawaz! Thanks fro your support : )

[@manoharchaudhary6505]

Your videos are very easy to understand. Your videos are great and very helpful. With your videos Excel is really a fun to learn. Thanks for the videos Sir.

[@excelisfun]

You are welcome, Manohar!!! Thanks for your support on each video that you learn from with a comment and thumbs up, and of course your Sub : )

[@trustinwwjd1997]

Whoa,,, what awesome Excel courses your teaching on YT Mr. Girvin,,,, Even with my limited brain-numbers, I can't help but finding your teaching so fun & interesting to keep watching! Also, Im let my friends n relatives know about your ExcelIsFun on YT ! GOD bless for all your good works,,,

[@excelisfun]

Thanks for telling others about the fun and knowledge at excelisfun at KZbin : ) TRUSTin WWJD!!!!

[@lindaokina2755]

These videos have helped me a lot. Thank you very much.

[@craigvoss1468]

Thanks for all your videos. I appreciate you sharing your knowledge and your great ease at demonstrations.

[@excelisfun]

You are welcome for all the videos! Thanks you for the support with your comment, Thumbs Up and Sub : )

[@SyedMuzammilMahasanShahi]

Thanks for all the efforts you are putting in Mike. Love it, EXCELlent

[@excelisfun]

You got it!!! I am happy to provide the EXCELlent fun : )

[@deveshdangi7209]

Thanks, @excelisFun for this informative video.

[@excelisfun]

You are welcome, Devesh! Thanks for helping support the free education that i provide with comments and thumbs ups for each video that you learn from, Sub too : )

[@Nikol0zi]

Hey mike, In this excel file, HM(3) the task is" if one has more then 275000 he gets the bonus", your answer had >= sign which means 275000 and more, but the task is just more, so it should have been just > sign. Thanks for the great vids.

[@excelisfun]

Thanks, I just updated : )

[@MT0912]

Thank you for all your efforts!! Really enjoyed the video!

[@excelisfun]

You are welcome, Martina : )

[@northshoreunitarians6417]

Took this class from you at HCC years ago -- but am going through the videos again to review them. So much good info!

[@excelisfun]

That is great to hear!!! Did you take class from me, or someone else?

[@northshoreunitarians6417]

From you. My name was Janis Elain at the time (although I've married and changed my name since then). LOVED your class! Was originally supposed to take the shorter Excel class from you, but paid extra so I could stay in the class longer to take the full course.

[@northshoreunitarians6417]

From you. My name was Janis Elain -- but I'm remarried now and have a different name. Still love watching your Excel videos. They are always helpful!

[@excelisfun]

Awesome! Glad you can still have fun with Excel here at KZbin : ) It is great to hang out with you again, Janis Elain!!!

[@excelisfun]

Glad the videos and files are helpful!!! Thanks for your support, with your comments, Thumbs Up and Sub : ) It helps to keep providing free Excel Education!!

[@aamir_curious]

loving it!

[@excelisfun]

Glad you love it, cuz this video is formula epic : ) : )

[@Nyuklehead]

Really loved this lesson! There are so many cool things you can do in Excel.

[@excelisfun]

Yes, that is a fun one with all the formula tricks : )

[@gwadaguadeloupe4308]

Superb! Thank you so much again for the excellent video. I needed this for tomorrow! Thank you for taking the time to work so hard on this video. It has been very helpful!

[@excelisfun]

I am glad that it was helpful! Thanks for the support with your comment, Thumbs Up and Sub : ) What is it that you are doing tomorrow that you need this for?

[@milyk9448]

I got a new job and need this to perform my daily work in AR. This is very helpful.

[@simoymorales5370]

Another great and demonstrative video of the basics of Excel, thanks sir for your kind efforts. Very refreshing and edifying to watch.

[@excelisfun]

Awesome - glad it was edifying! Thank you for your support : )

[@sorenzollamas]

The text formulas were really helpful. I never understood those before. 🙏

[@excelisfun]

Glad the video helps : ) Thank your for the support with your comment and Thumbs Up : )

[@Whyvardhann]

You are a wonderful teacher!!!!

[@excelisfun]

You are welcome! Thank you for the kind words !!! Thank you also for the support with your comments, Thumbs Ups and Sub : )

[@adambechcinski]

Dear Mike! MANY THANKS for all your awesome Videos!!! Perfectly explained, interesting real life examples (such as accounting cases etc.), and many hints cleverly mentioned in each epizode so one cannot forget :) (e.g. Excel golden rules) IT HELPED ME A LOT !!!!!!! Greetings from Poland :)

[@excelisfun]

You are welcome! I am glad that hints throughout the videos help! Please help me too - with a Thumbs Up and short comment on each vid, and a Sub : )

[@Notexpected222]

Once again, thank you so much for taking the time to make such an incredible video.

[@excelisfun]

You are welcome for the time and fun! Thank you, David, for supporting the videos you watch with your comments, Thumbs Ups and Sub : )

[@MalinaC]

Brilliant as always :)

[@excelisfun]

Glad you like it! Thank you for your support.

[@Kizo_55]

Thank you!

[@excelisfun]

You are so welcome!!!!! Keep going : )

[@brendarolph9833]

Thank you for your excellent videos! I love them all!

[@excelisfun]

You are welcome, Brenda!!!! Thanks for the support with your comment, Thumbs Up and Subscription : )

[@brendarolph9833]

Hello Again. Do you have an Excel video(s) that you can recommend that would help explain how to calculate the present value of future lease payments (this would be used for GASB #87 which you may not be familiar with but is probably not relevant) and in addition, a video to create an amortization schedule to be used for the monthly lease payments separating them into interest and principal? Thank you!

[@Chamchijjige]

Thank you. You are great teacher.

[@excelisfun]

You are welcome!

[@wasd7616]

Thank you for this interesting explanation

[@idanbenruby8741]

love your work! excel can definitley be fun..

[@excelisfun]

Yes!!! Glad it is fun for you, Idan! Thanks for the support with your comment, Thumbs Up and Sub : )

[@yebonemyatphoethar602]

thanks you so much sir!

[@excelisfun]

You are welcome!

[@houssamayoubi8715]

Big thank you for a great effort.

[@chandu7spark]

Learning a new thing (Text Formulas). Tanq Soo much :)

[@excelisfun]

You are welcome for the Text Formula Fun, Bhart!!!

[@anuragmishra1701]

Thanku so much sir.

[@excelisfun]

You are welcome!!!!

[@DewinaBu]

Thank you so much, love your videos!

[@excelisfun]

You are welcome, Debry!!! I love the support with your comment, Thumbs Up and your Sub : )

[@COLOSALCOLOSO]

Another great video, really well explained thanks!

[@excelisfun]

You are welcome! Thanks for the support with your comment, Thumbs Up and Sub : )

[@Aabr123-ep2wz]

thank you so much

[@excelisfun]

You are welcome!!

[@mariuszwiesiolek5777]

As an bonus, in HW(3), add function that counts how many people will get bonus:-)

[@moparnas8377]

Love these videos! Thanks!

[@excelisfun]

Glad you love the videos! I love making them - so it works out : ) Thanks you for your support with your comment and Thumbs Up !!!

[@ismailismaili0071]

thank you so much Mr. Mike it was really useful i love you

[@excelisfun]

Love is what makes the world fo around! I am glad that the video helps and thanks for your support : )

[@mr.perfect6814]

Guru ji thanks a lot for Your all excel vedio. I no need to go computer coaching center to learn excel.

[@excelisfun]

You are welcome a lot! Yes that is true: all you have to do is come here and watch Excel Fun Videos! Thanks for your support with a comment and Thumbs Up on each video, and of course a Sub so you know when new and fun videos come out!!!

[@BK-kp6rr]

Thank you again for teaching

[@excelisfun]

You are welcome!

[@sunnybansal9294]

All your videos are really helpful and it makes me easy to learn excel..but I have a doubt that what if I need to split a name into first name in one cell and last name in another cell then what is the formula that will work ??

[@mohamedchakroun4973]

Always something new to catch go team

[@excelisfun]

Go Team!!!! : )

[@alechkoofficial]

Thanks great video, what the difference between the join operator and the concatenate function?

[@excelisfun]

They both do the same thing. But because the Join operator is easier for Logical formulas and comparative operators, I tend to use Join Operator all the time. Either is fine, though.

[@alechkoofficial]

@@excelisfun thanks

[@krn14242]

Thanks Mike. Great review.

[@excelisfun]

You are welcome, WRH!!!!

[@lisamccray6481]

You are one fantastic person. Kinda like Alt=Sum($Moses+$Jesus+Einstein). Now I gotta get back to the video.

[@excelisfun]

Alt + = !!!!!

[@lisamccray6481]

I really appreciate your attention to even the exta details that matter. At the end you note that subtraction happens before comparative operators "just like in the list." Very grateful.

[@excelisfun]

@@lisamccray6481 Glad you like that detail, Lisa : ) : ) : ) : )

[@swanakhune7397]

This video was very informative

[@excelisfun]

Glad it was informative for you! Thanks for your support, Swana, with your comment, Thumbs Up and Sub : )

[@samfrench6253]

Great lesson

[@excelisfun]

Thanks for the support with your comment, Thumbs Up and Sub : )

[@tammieknuth6020]

Wording is extremely important. Like the word "for" ir "like"

[@everythingiseverything5299]

Great video

[@excelisfun]

I am glad that you figured out your >=55000 issue : )

[@BakwasBlog]

You are doing a great job, My query is how to calculate alternative cells, e.g.. I want to sum a1, a3, a5, a7..... OR a1, c1, d1.... so on can you please share the link of the tutorial?

[@bavajikj3267]

Awesome job, thank u so much

[@excelisfun]

You are welcome so much!

[@kisslaci36]

I saw most of these functions in you VLOOKUP week videos, but it is great to pin down the basics using them separately.

[@excelisfun]

Yes!!!! Nothing like a Basics video that covers all the topics in one place : )

[@arunkhanal7208]

Mike, At Cell A1 of the Sheet >>HW(3an)

[@wasd7616]

good lesson thank you

[@excelisfun]

You are welcome, wasd!!! Thanks for your support : )

[@TrailShake]

Thanks!

[@stephanieclancy254]

Wonderful!

[@excelisfun]

Glad it is wonderful for you, stephanie!!!! Thanks for your consistent support : ) : )

[@seanmen4141]

Interestingly, when join two numbers using cell reference, eg 9 in A1 and 9 in A2, using A1&A2, the result looks like text, but you can still use it to plus 1 in another cell to get 100.

[@excelisfun]

That is correct: 1) Using the Ampersand Join Symbol will convert the items to text, and 2) Using a math operator (like +1) will convert text numbers to numbers that can be use for math.

[@ndelpurg]

THE EXCEL GODS ARE PLEASED AGAIN!

[@excelisfun]

Glad you like the video!

[@grizzygriz7957]

Hi. In example #12, is there a different way to enter that formula since the on hand units were already calculated in column D? I entered the formulas as =D166

[@jedrzejszumniak4675]

All your videos are great. Do you have any big data sets with questions of different levels that you can use to practice excel? I used the ones provided (sometimes the site seems to be down so I can't get through) but do you have any other sets of data to practice on?

[@NeoJack-one]

thanks mike !!

[@excelisfun]

You are welcome, nitesh!!!!

[@wesleymurphy3823]

Question. In example #8, when you extracted the product number, how come the excel rule that a number lines up to the right did not apply?

[@robertohernandez2124]

I don't deserve you :) AMAZING!

[@excelisfun]

Yes you do deserve this!!!!!

[@nabilnabil1824]

thanks ,teacher

[@excelisfun]

You are welcome, Nabil : ) : )

[@PedroCabraldaCamara]

Hello Mike. I'm a big fan of all your videos since i can remember. But now i'm struggling with my boss about a formula to calculate the COGS. I've been looking all over your videos and all of internet for it, and it seems everyone has a different opinion about it. Can you help me? Can you send me a link of one of your classes that explain how can i calculate it? Thank you so much for everything

[@tocodelray]

Good stuff

[@Nikol0zi]

thank you a lot!

[@kamal_Rautela]

love from india

[@excelisfun]

Glad you love it! Thanks for your support with your comment, Thumbs Up and Sub : )

[@Tebony2]

Hi, I'm so sorry but I don't really understand the rule of the double quote. Can you please explain it to me. When should i put in double quote?

[@shrek8722]

Hi, you sound a lot like Ross from friends..

[@johnborg6005]

Thanks Mike :)

[@excelisfun]

Thank you too for your consistent support, it means a lot : )

[@ashach3360]

Hi Sir, what if I need to extract product code like Aspen,quad..which function do we need to use??

[@MrRamonm718]

I love excel

[@excelisfun]

Me too! Thanks for your support, MrRamonm718!!!

[@jenniferobiezu353]

❤

[@pramitmehta258]

Mike, thanks a lot for videos! I needed one advice. It has only been a couple of months that I switched over to Mac book air. I am literally struggling to use excel in Mac. I used excel on Mac before. Would it be a good idea to buy a cheaper wireless keyboard?

[@krn14242]

Excel for the MAC is not "real" Excel. :)

[@pramitmehta258]

krn14242 but is the microsoft excel 2016 from Microsoft.. I m not talking about numbers

[@excelisfun]

krn14242 is correct. over the last 10 years most of the great new features in Excel PC (Power Query, PowerPivot, New Functions, Relationships, Data Model and many others) are not in Mac Excel. I have no idea why Microsoft made the choice to not include the many new analytic tools in Mac Excel, but this fact makes it no longer viable in the business world.

[@pramitmehta258]

ExcelIsFun thanks a lot for all your insights. So,if i really want to learn excel,would you recommend installing Windows in mac? I would really appreciate your guidance. Thanks

[@excelisfun]

I do not know how to install windows on Mac and I really know nothing about Mac... Even though i ran my business with Mac Excel in the 1990s, over the years I just had to switch because Mac Excel was not providing for my particular Excel and Business Needs... I loved my Mac Excel in the 1990s... But i no longer know anything about Mac Excel.

[@toufiq1ul]

Hello sir, I’m from uk. I’m a training myself for accounting assistant. I have been through many interviews for accounting assistant. The employer asked me questions regarding excel. I would request you to tell me which excel formulas and function I should be learnt to work efficiently in excel for accounting. Tia

[@excelisfun]

There is not just one formula. You must know the foundation of Excel. This class teaches that. It takes an investment to learn Excel. But it is worth it : )

[@toufiq1ul]

@@excelisfun thanks sir

[@JoseMoralesOfficial]

Can anyone help me? I’m trying to figure out a formula. I have customers that take surveys. The surveys are rated 1-5. I look at the 5s for scoring purposes. If for example I get 13 surveys and end up with 68% of those surveys being 5 rating ones. How would I create a spreadsheet that will tell me how many more surveys with a 5 rating will I need to get to 80% The formula would need to be able to be adjusted for whatever % I want to know. So in the example above, if I decided that maybe I want to know what 75% would be instead. Any help would be greatly appreciated!

[@zaibakhanum203]

U r awesome..

[@excelisfun]

Glad to help!!!

[@zaibakhanum203]

Sir I have some data, need to perform operations on that could u plz help me out ..

[@AoiTodo998]

hey teacher , at this note (Page 1) > 3) > iii ,, you have type Antitime , and i think you mean Anytime , my english is bad so Antitime lead me to use google translation xD

[@excelisfun]

I am sorry about the spelling error.

[@hfabillar2603]

Good day, please give me a link to a lesson that can reduce the memory consumption if my spreadsheet already has a bunch of formulas. thank you.

[@excelisfun]

I am sorry but I do not have a video lesson on that.

[@hfabillar2603]

ExcelIsFun good day. Thanks for d reply. I happened to see one of your vids, just didn.t took note what lesson. My fault. What i mean about minimizing the calculation loading is: when u add "iferror = 0 or isblank = 0" to the main formula. I hope you could recall. Thanks a lot.

[@alanmonaghan9194]

Hi Mike, first of all, great video as usual, but for HW(3) the way the task is worded, should the answer not be =B4>$E$4 rather than =B4>=$E$4 in cell C4?

[@excelisfun]

Yes it should!!! Thanks for helping me find that error. I have fixed the workbook so that other teammates with benefit : ) Thanks, Alan!

[@alanmonaghan9194]

@@excelisfun No worries Mike. I'm going over the Basic classes again as a refresher and I'm still finding things I missed first time around, so thanks for the great work you put into this.

[@excelisfun]

@@alanmonaghan9194 Thanks for helping support what I do with your comments and thumbs ups : )

[@SteveCancel78]

Hi Mike you may have covered this but I was hoping you could help me with something. I have a very large report that I produce from my applicant tracking system and it outputs the information in columns A through G. Column A is first name, Column B is last name. I have a source who sends me lists of names in a different format but thanks to your videos I was able to take that data and convert the data into columns by the comma delimeter (he sent to me as last name, first name). Now that I have matching data sets, I need to see if the list of names match up with names I have in my very large report, so basically I have one list that is only 50 names long but another list that has 300. My main source has around 2000+ names. I essentially want to find the duplicates to see if the names he’s providing to me match with any of the names on my list- if they do, I need to input the information from my spreadsheet into his (essentially the status field which is column G) I guess I could use a vlookup for that but what’s the best way to identify where I have the matching data and then take the data in column g and input it into let’s say column C of his sheet.... I’m totally stumped. I thought of using conditional formatting and seeing where the colors line up but I don’t know if that’s the best way.... I hope I’m making sense.... if you could point me in the right direction and/or if you have a video that covers this I’d really appreciate it!! Thanks so much! You’re awesome!

[@excelisfun]

I can't help right now, not enough hours in day. Anyone else Know? Otherwise, post question to: mrexcel.com/forum

[@brianxyz]

If your main source has ~2,000 names and someone is sending you another list why are there three lists mentioned? Have you considered using Power Query (Get and Transform)? I would set up your master table as one query and the table sent to you as another. Then do a Merge query where the Join Kind is Left Outer. You can match up the common fields to retrieve the records in the list sent to you that have matching names in the master list. This will allow you to create a new table that contains the info you want to send back to the person who sent you the differently formatted list. I think this should work if I understand your situation correctly. If it does work you'll be able to easily automate the process in the future.

[@krishnavalli2910]

Hi, when I download and opened the file in the cover sheet instead of formulas it is showing "#NAME?". why it is like that? I am using excel 2007. Is anything do with the version? Please suggest the solution. Thank you

[@excelisfun]

I am happy to help, but it looks like you did not click Thumbs Up...

[@excelisfun]

Yes, it is because you do not have Office 365. There are many, many useful and amazing new functions and features in the latest version that are not in Excel 2007.

[@krishnavalli2910]

Okay! Thank you so much for immediate response.

[@excelisfun]

You are welcome, krishna! Thanks for the Thumbs Up on each video that you watch, comments when you are inspired and a Sub : )

[@excelisfun]

By The Way, krishna, this whole series is all about Office 365 and it really has new features that are just not in Excel 2007, so to best complete tasks in Excel it is really helpful to have the latest version : )

[@dianemassingberd6042]

Hello there I want to calculate hours by pay rate of employee. So if employee "Jane Doe" multiply Column c by $20.00 if employee "john doe" then multiply column c by 15.00

[@excelisfun]

VLOOKUP video: kzbin.info/www/bejne/sKKpdmmrfq9pa9U Be sure to click that Thumbs up and leave a comment to show support : )