Create a Formula... Continued

An example of a formula mixing operators:

            =(A2)*((B2)+(C2))

Here it is necessary to add the values in B2 and C2 before multiplying the sum by the value in A2. If you write the formula including the brackets the computer will calculate the answer correctly, otherwise it will simply work from left to right multiplying A2 and B2 first before adding C2 to the product. This would give you a very different answer.

Create a formula (15 minutes)

Let’s see if you can devise the correct formula to work out the difference between Income and Expense in the Enterprise columns of the worksheet. In the pink row below the ‘Totals’ row and in the Enterprise Cattle column, insert a formula that works out the difference between Income and Expense. This is important because it will indicate to what extent the enterprise has been profitable. In the example table we inserted the formula twice, once for Cattle and again for Maize. Copy the formula into as many Enterprise columns as you have created to find their profitability.