Excel 2010 VBA Tutorial 7 - Numerical Operations and Decimal Points

An incite into Double Variables and how to use other numerical operations.

[crazyidiot]

First, thanks for making these great VBA tutorials. They are fantastic. I am from the USA and PEMDAS is

Parenthesis
Exponents
Multiplication
Division
Addition
Subtraction

[wasimbader]

thank you for your great efforts in teaching VBA, "Excel"

[rinawhite]

in Quebec I was taught BEMDAS

Brackets
Exponents
Multiplication
Division
Subtraction

Man, that takes me back, though! :)

[carlosbarbosa]

Very good lesson's VBA for Excel, congratulations

[colina]

BODMAS!  High school flashback!  Thanks for all the videos - they've been great.  

[augustelmoutima]

PEMDAS stands for ( Please = Parenthesis, Excuse= Exponential, My= Multiplication, Dear= Division, Aunt=Addition, Sally= Subtraction) this is the simpler way to understand the order of operation.

[IJustMadeAComment]

Thanks for these videos. They are a good intro into VBA. Do you have any, or recommend any other, videos/websites for more complex programming techniques? Thanks

[YourprogrammingnetworkCoUk]

yeh we use bodmas (Brackets over division, multiplication, add, subtract

Never heard of pemdas before, what does it stand for?

What country are you from?

[inspirationstation]

This video gives me a Run-time error '6' Overflow. Does it work the same way if I am using MS excel on a mac?

[TheBootsie]

Thanks for these tutorials! I spend most of my day at work coming up with spreadsheets and templates but had no considered programming to make my life simpler before hand. I watch these tutorials during my lunch break and give it a go. I notice that when there's an error -it is highlighted in yellow but I can not find out exactly what the error is, it simply states there is an error. Any advice?

[deeskie]

If I have a text box on my userform and I want it to show a number in currency format how would I go about that?

[Francis-qfhr]

bodmas= bracket, OF(multiplication of another form), division, multiplication, addition and 2 of 3*2/6 is gonna give you 2....thanks for the video anyway

[jeremiel]

Hi!
I really love your tutorials. But one small thing, I don't think doubles use more memory than intetegers. I don't know exactly how Excel functions but I have been working with a couple of other optimization softwares and Integers usually require more memory than doubles.
Integers may be seen as a lot of different variables (1, 2, 3, ...), and double may be seen as one straight line. (y=x)

[nashed]

Please excuse my dear aunt Sally
PEMDAS
Parenthesis
Exponents
Multiplication
Division
Addition
Subtraction

[Jackorite]

Face of BOE (Brackets over everything)

[crazyidiot]

you should have done the convention:

PEMDAS

unless its different in your country