Aussie rules

Tags
IPO
Challenge
No

Australian Rules is a type of football. You score points by getting the ball between posts at either end of the field:

Aussie rules

If the ball goes between the center two posts, that's a goal, and is worth six points. If the ball goes between one of the center and outside posts, that's a behind, and is worth one point.

Make a worksheet that starts like this:

Start

The user enters values for goals and behinds, clicks the button, and your VBA program outputs the total score. Here's an example:

Output

Here's another example:

Another example

Upload your workbook.

Where referenced