Good morning. I want to create a spreadsheet which tracks performance to target but only shows values when the result is positive. The spreadsheet I have created shows the following by column - TARGET, ACTUAL MONTHLY CUMULATIVE, DIFFERENCE (+/- value), 7.5% of target value (assuming that target has been achieved) 10% of VALUE IN EXCESS of TARGET, COMBINED VALUE OF the 7.5% & 10%. If target isn't achieved then I don't want any value showing.
<colgroup><col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;"> <col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" span="2"> <tbody>
</tbody>
Date | Target | Actual (Daily) | Actual (cumulative) | Diff | 7.5% | 10.0% | Total | |
2nd | £800 | £600 | £600 | -£200 | £60 | -£20 | £40 | |
3rd | £1,600 | £600 | -£1,000 | £120 | -£100 | £20 |
<colgroup><col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;"> <col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" span="2"> <tbody>
</tbody>