create account

VBA Excel 2016 Lesson 5 - Averaging numbers in VBA by magicmonk

View this thread on: hive.blogpeakd.comecency.com
· @magicmonk ·
$11.11
VBA Excel 2016 Lesson 5 - Averaging numbers in VBA
<figure class="wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio"><div class="wp-block-embed__wrapper">
https://www.youtube.com/watch?v=N8p19we5sUc
</div></figure>
<p> Today we introduce you to two ways to average numbers in VBA - using numerical operators or the WorksheetFunction object. </p>
 <br /><center><hr/><em>Posted from my blog with <a href='https://wordpress.org/plugins/steempress/'>SteemPress</a> : http://magicmonktutorials.com/blog/2020/01/31/vba-excel-2016-lesson-5-averaging-numbers-in-vba/ </em>
<br />
<img src="http://magicmonktutorials.com/images/logo_medium.jpg"><br />
<b>Mathematics & Digital Technologies Education</b><br />
<b>Videos, quizzes, and other learning resources</b><br />
Eddie the Magic Monk has 15 years teaching experience as a high school teacher in Australia. He will explain things to you in the simplest way possible to help you fully understand high school mathematics and computer science concepts. <br /> 
Eddie began his tutorial channel on Youtube in 2012. His videos have been well received all over the world and now has 20+ million views! He sees the benefit in multidisciplinary learning hence his tutorials cover topics ranging from maths to dance. <br /> 
<hr/>
</center>           
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 297 others
👎  ,
properties (23)
authormagicmonk
permlinkvbaexcel2016lesson5-averagingnumbersinvba-xn9ue6k4bu
categoryhive-122108
json_metadata{"community":"steempress","app":"steempress","image":[""],"tags":["hive-122108","palnet","steempress","steemstem","technology"],"canonical_url":"http://magicmonktutorials.com/blog/2020/01/31/vba-excel-2016-lesson-5-averaging-numbers-in-vba/"}
created2020-01-31 10:27:30
last_update2020-01-31 10:27:30
depth0
children5
last_payout2020-02-07 10:27:30
cashout_time1969-12-31 23:59:59
total_payout_value5.889 HBD
curator_payout_value5.221 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,309
author_reputation1,108,106,833,466,351
root_title"VBA Excel 2016 Lesson 5 - Averaging numbers in VBA"
beneficiaries
0.
accountsteempress
weight1,500
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id94,954,947
net_rshares47,407,299,115,341
author_curate_reward""
vote details (363)
@beerlover ·
<div class='pull-right'>https://cdn.steemitimages.com/DQmaHThyECGhEx8tSfHZbiMFRNYjJ35K92cDgiJjkzBUaJo/One%20sip%20of%20BEER%20for%20you.gif<p><sup><a href='https://steem-engine.com/?p=market&t=BEER'>View or trade </a> <code>BEER</code>.</sup></p></div><center><br> <p> Hey @magicmonk, here is a little bit of <code>BEER</code> from @eii for you. Enjoy it!</p> <p>Learn how to <a href='https://steemit.com/beer/@beerlover/what-is-proof-of-stake-with-beer'>earn FREE BEER each day </a> by staking.</p> </center><div></div>
properties (22)
authorbeerlover
permlinkre-vbaexcel2016lesson5-averagingnumbersinvba-xn9ue6k4bu-20200131t194221z
categoryhive-122108
json_metadata"{"app": "beem/0.21.1"}"
created2020-01-31 19:42:24
last_update2020-01-31 19:42:24
depth1
children0
last_payout2020-02-07 19:42:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length520
author_reputation25,804,836,603,936
root_title"VBA Excel 2016 Lesson 5 - Averaging numbers in VBA"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id94,970,647
net_rshares0
@cnbuddy ·
你那里天气如何?想来玩目前STEEM上最火爆的drugwars游戏吗?还在等待什么?赶快加入战斗吧![drugwars.io](https://drugwars.io/i/davidchen)假如我的留言打扰到你,请回复“取消”。
properties (22)
authorcnbuddy
permlinkre-magicmonk-vbaexcel2016lesson5-averagingnumbersinvba-xn9ue6k4bu-20200131t103240590z
categoryhive-122108
json_metadata""
created2020-01-31 10:32:42
last_update2020-01-31 10:32:42
depth1
children0
last_payout2020-02-07 10:32:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length115
author_reputation-1,449,160,991,441
root_title"VBA Excel 2016 Lesson 5 - Averaging numbers in VBA"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id94,955,067
net_rshares0
@eii ·
!BEER
properties (22)
authoreii
permlinkq4zled
categoryhive-122108
json_metadata{"app":"steemit/0.1"}
created2020-01-31 19:42:12
last_update2020-01-31 19:42:12
depth1
children0
last_payout2020-02-07 19:42:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length5
author_reputation180,988,728,753,970
root_title"VBA Excel 2016 Lesson 5 - Averaging numbers in VBA"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id94,970,642
net_rshares0
@steem-ua ·
#### Hi @magicmonk!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your **UA** account score is currently 4.747 which ranks you at **#1595** across all Steem accounts.
Your rank has dropped 10 places in the last three days (old rank 1585).

In our last Algorithmic Curation Round, consisting of 87 contributions, your post is ranked at **#6**.
##### Evaluation of your UA score:

* Some people are already following you, keep going!
* The readers appreciate your great work!
* Try to work on user engagement: the more people that interact with you via the comments, the higher your UA score!


**Feel free to join our [@steem-ua Discord server](https://discord.gg/KpBNYGz)**
properties (22)
authorsteem-ua
permlinkre-vbaexcel2016lesson5-averagingnumbersinvba-xn9ue6k4bu-20200131t212823z
categoryhive-122108
json_metadata"{"app": "beem/0.21.0"}"
created2020-01-31 21:28:24
last_update2020-01-31 21:28:24
depth1
children0
last_payout2020-02-07 21:28:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length731
author_reputation23,214,230,978,060
root_title"VBA Excel 2016 Lesson 5 - Averaging numbers in VBA"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id94,972,789
net_rshares0
@steemitboard ·
Congratulations @magicmonk! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

<table><tr><td><img src="https://steemitimages.com/60x60/http://steemitboard.com/img/notifications/postallweek.png"></td><td>You published a post every day of the week</td></tr>
</table>

<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@magicmonk) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=magicmonk)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>


To support your work, I also upvoted your post!


###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!
properties (22)
authorsteemitboard
permlinksteemitboard-notify-magicmonk-20200201t033144000z
categoryhive-122108
json_metadata{"image":["https://steemitboard.com/img/notify.png"]}
created2020-02-01 03:31:45
last_update2020-02-01 03:31:45
depth1
children0
last_payout2020-02-08 03:31:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length861
author_reputation38,975,615,169,260
root_title"VBA Excel 2016 Lesson 5 - Averaging numbers in VBA"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id94,979,944
net_rshares0