Free Pittsburgh Excel Seminar on Nov 12 2014: Wands: Excel Reporting Tools for Oracle EBS & SAP - insightsoftware
I was a bit surprised when I saw Bob Phillips from the UK roll out a formula where the % sign was used as an operator. You have a cell address, like C3. Slap a % symbol after that in the formula and Excel divides the cell by 100.
I was a bit surprised when I saw Bob Phillips from the UK roll out a formula where the % sign was used as an operator. You have a cell address, like C3. Slap a % symbol after that in the formula and Excel divides the cell by 100.
Transcript of the video:
MrExcel podcast is sponsored by excel4apps.
Excell solutions for Oracle and SAP.
Hey, check that out, over there on the left-hand side, that is my 44th book.
It's due out in early 2015: POWER EXCEL with MrExcel.
But if you want to get a copy of that book and you are anywhere near Pittsburgh, Pennsylvania, what an amazing opportunity!
On Wednesday November 12th 2014, in the afternoon, starting at 3 o'clock, right downtown Pittsburgh PA, the great folks at excel4apps are sponsoring a Power Excel Seminar.
That's right, if you sign up, come to the seminar, it’ll be an hour and a half of me doing Excel tips and tricks.
Everyone who shows up gets a free copy of the new book, way before you can buy it.
Plus hors d'oeuvres and a draw-in for an iPad mini.
The link to register is right down there in the YouTube description, check it out, would love to see you there.
As far as I'm trying to remember, I think this is the first public event I've ever done in Pittsburgh.
Check it out, if you're in western Pennsylvania, heck, even eastern Ohio!
Hey, you can catch a ride over there with me, from Akron, Ohio, if you want.
Come, check us out.
Learn from MrExcel podcast, episode 1936.
=C3%*B3.
Whoa!
The % symbol really is an operator.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, I just saw this last week: Bob Phillips, an Excel MVP from the UK, hit us with this form, that =C3%*B3.
What the heck is that sC3%?
3%, what's the C?
Oh, this is amazing, so I check this out.
And, C3: someone put it in a Tax Rate, but they didn't bother to put it in as a percentage, they just put 6.5, not 6.5%.
Never know if this would work, if =C3% -type the % sign right there, the % is actually an operator- *B3. Bam, and it does the right thing.
It takes that value at C3, divides it by 100 or multiplies it by 0.01, whatever you want to do.
And then does the rest.
It's kind of, like the unary minus.
Unary minus sign is an operator, you can say –C3, I guess that's not surprising at all.
But I've never seen anyone, actually use the C3%.
So hey, I want to hear from you, down in the YouTube comments.
Tell me what's your reaction is: this “Wow, I've never seen that!” or “Oh, yeah, I do this all the time”.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast – MrExcel.
Excell solutions for Oracle and SAP.
Hey, check that out, over there on the left-hand side, that is my 44th book.
It's due out in early 2015: POWER EXCEL with MrExcel.
But if you want to get a copy of that book and you are anywhere near Pittsburgh, Pennsylvania, what an amazing opportunity!
On Wednesday November 12th 2014, in the afternoon, starting at 3 o'clock, right downtown Pittsburgh PA, the great folks at excel4apps are sponsoring a Power Excel Seminar.
That's right, if you sign up, come to the seminar, it’ll be an hour and a half of me doing Excel tips and tricks.
Everyone who shows up gets a free copy of the new book, way before you can buy it.
Plus hors d'oeuvres and a draw-in for an iPad mini.
The link to register is right down there in the YouTube description, check it out, would love to see you there.
As far as I'm trying to remember, I think this is the first public event I've ever done in Pittsburgh.
Check it out, if you're in western Pennsylvania, heck, even eastern Ohio!
Hey, you can catch a ride over there with me, from Akron, Ohio, if you want.
Come, check us out.
Learn from MrExcel podcast, episode 1936.
=C3%*B3.
Whoa!
The % symbol really is an operator.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, I just saw this last week: Bob Phillips, an Excel MVP from the UK, hit us with this form, that =C3%*B3.
What the heck is that sC3%?
3%, what's the C?
Oh, this is amazing, so I check this out.
And, C3: someone put it in a Tax Rate, but they didn't bother to put it in as a percentage, they just put 6.5, not 6.5%.
Never know if this would work, if =C3% -type the % sign right there, the % is actually an operator- *B3. Bam, and it does the right thing.
It takes that value at C3, divides it by 100 or multiplies it by 0.01, whatever you want to do.
And then does the rest.
It's kind of, like the unary minus.
Unary minus sign is an operator, you can say –C3, I guess that's not surprising at all.
But I've never seen anyone, actually use the C3%.
So hey, I want to hear from you, down in the YouTube comments.
Tell me what's your reaction is: this “Wow, I've never seen that!” or “Oh, yeah, I do this all the time”.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast – MrExcel.
