You have some Snow Whites and some dwarves. Each Snow White needs seven dwarves, but you might have more or fewer dwarves than you need. Write a program to figure out how many dwarves to add, or get rid of.
It starts like this:
Make sure that the two input values are numeric, and zero or more. Show errors in the worksheet:
Make sure that the errors and output from one run are cleared when the next run starts.
Here are output samples. Note that singular/plural is handled correctly. You'll needs some
Ifs for this.
Upload your workbook. The usual coding standards apply.
dwarvesNeeded = snowWhites * 7 dwarvesChange = dwarvesNeeded - dwarves