Airfix9
Well-known Member
- Joined
- Sep 23, 2005
- Messages
- 886
Hi Mr Excel-land - I have a nutty one!
I am building a bonus template for our salesforce which shows how they are performing against their pre-agreed criteria. Essentially, it works on % of annual salary (so, if this criterion is met then they earn 5% of annual salary and so on).
I would like this to be fairly funky so that, if they enter their annual salary in cell E4, the percentages change to £ values instead (thus, showing what they have ACTUALLY earned).
In order to manage this, I have done the mathematical calculation for the formula in the cell but was wondering if there is a non-VBA method to change the actual cell format? I have been working with the following customised format:
...but, if the £ value is below £1 (as it may be in certain circumstances), then this appears as a percentage instead of a monetary value. The percentage will never be over 100% as it is percentage of maximum bonus.
Any ideas, please? I am completely mystified!
I am building a bonus template for our salesforce which shows how they are performing against their pre-agreed criteria. Essentially, it works on % of annual salary (so, if this criterion is met then they earn 5% of annual salary and so on).
I would like this to be fairly funky so that, if they enter their annual salary in cell E4, the percentages change to £ values instead (thus, showing what they have ACTUALLY earned).
In order to manage this, I have done the mathematical calculation for the formula in the cell but was wondering if there is a non-VBA method to change the actual cell format? I have been working with the following customised format:
Code:
[>1]£#,##0.00;[>0]0.00%;""
...but, if the £ value is below £1 (as it may be in certain circumstances), then this appears as a percentage instead of a monetary value. The percentage will never be over 100% as it is percentage of maximum bonus.
Any ideas, please? I am completely mystified!