Excel Basics #5: Formulas Operators and Math

[blizzal2]

how about? 2 types of concrete have different types of limits its either xc1,xc2,xc3,xs1,xs2,xs3,xd1,xd­2,xd3. for all of these there are a seperate table each for 100 or 50 years. and each of these tables there is a list of different cover values 15,20,25....60. So basically my lecturer wants me to be able to make a working programme where you input for example xc2,cover 15,at 100 years and the limit would just pop up...I have all the limits i just need to know what formula to use?

[ExcelIsFun]

@blizzal2 , stop posting the same question on 10 different videos!!!

[excelsiormc86ss]

Would there be any chance of getting a hold of your workbooks? The link no longer works.

[ExcelIsFun]

people.highline.edu/mgirvin/Ex­celIsFun.htm

try the 2007 link

[gbc175]

Glad you made this... I have learn a lot from your videos... God bless and keep up the good work!

[ExcelIsFun]

You are welcome!

[arareboston]

I would like to say that I've enjoy watching/learning excel from your clips tremendously. It is really helpful for an excel inept person like me! Thank you very much and keep up the great work!

[ExcelIsFun]

You are welcome!

[TXRider]

Thank you so much! I took an office assistant course that was supposed to teach me enough about Excel to get a job. Well, I took an interview with an Excel test and I knew only basics, and I KNOW I studied hard. I know my textbook wasn't very good.

[ExcelIsFun]

I am glad that the videos help - that is why I put them out there!

[govtmule1979]

Is it ok to say aucking fmazing?

[ExcelIsFun]

Yes! Actually, you can say what ever you want - I am just glad that the videos are helpful to you!

[ExcelIsFun]

That's funny!

[steven94116]

You are fucking amazing!!!!! I love your mini courses!

[ExcelIsFun]

I am glad that ypu like them.

But please, no swearing! Those kinds of words are better left for car accidents when someone who was texting hit your car!

[darkwizzard70]

I love this , you are really really great !!

Thanks man , its really basic and fun to learn from.

[ExcelIsFun]

You are welcome!

[snijran]

You have helped me a great deal! Thankyou!

[ExcelIsFun]

You are welcome!

[shinderalla]

Your videos are very informative! thank you!

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

Follow this Basis series (1 - 23) and the 'Highline Excel Class' Series (1 - 59) and you will see many helpful videos.

[Raeb222]

I am learning Excel 2007 and am confused about the order of operations.

Thank you for your videos. Please more like this :)

[missmik84]

All of your videos are awesome! I was a dummy when it came to Excel, but now I am confident thanks to you. Thanks for your time and your workbook!!! YOU ARE AWESOME!

[ExcelIsFun]

You are welcome - I am glad that they help!

[ashirocking]

Thank you millions, u r amazing teaching skills

[ExcelIsFun]

I am glad that it is helpful!

[thesuperdarren]

You simply brilliant!

[ExcelIsFun]

Thank you. I am glad that you liked the videos!

[HellDriver6]

I love you teacher :D

[ExcelIsFun]

Now that is cool:

Love from a HellDriver!!!

I am glad that the video is helpful to you!

[fahadsaeed50]

great video

[ExcelIsFun]

I am glad that it helps!

[slaves2sin]

-2^2 = 4??!!! Wow i learned something today. excel should make that -4 fo sho!

[ExcelIsFun]

Dear slaves2sin,

Yes, Negation comes first! Learning Excel is quite fun!

--excelisfun

[sylwienzik]

I was suprised too! I guess sometimes excel needs a little hint :)

[gastonytHQ]

raising -'s to ^2, will always return as a positive

[zhaoli86]

This is amazing, thanks for your videos.

[ExcelIsFun]

Dear zhaoli86,

You are welcome!

--excelisfun

[scottylad2]

I've learned so much from Excels Fun,thought i'd let you know that i'm downloading the series all over again so my 70 year old father can learn it!

I use them for making staff rotas and time sheets for work and i've made the most amazing Flexi-time sheet for my wifes work. It calculates her hours, and if she goes a minute over or under in any week we can find it, It allows her to know if she owes or is owed hours, and i can track it for a whole year so a big thanks.

've learnt so much from it

[ExcelIsFun]

Dear scottylad2 ,

I am glad that the videos are useful!

--excelisfun

[periwink]

Another handy video ! :) 5 stars. Thanks

[ExcelIsFun]

Dear periwink,

I am glad that you find the videos useful!

Hey, periwink, did you notice that I re-did the Basics Series? You watched, the old 14 video Basics Series, right? If so, how do you like this new 23 video Basics Series?

Also, this video, Excel Basics #5: Formulas Operators and Math, is quite useful, especially the list of how Excel Evaluates formulas. Excel does not just have to deal with PEMDAS, but also : (colons), , (commas), > (greater than) and more!

--excelisfun

[ExcelIsFun]

You are welcome!