trickster1978
Board Regular
- Joined
- Oct 22, 2009
- Messages
- 67
Hi,
I run a subscription club to a club. We are putting in place new pricing, as there is a huge amount of historical prices in there that we need to get back in line.
In summary, the new prices will be £40 per month. Some pay this already, so will hold that rate.. so pay a lot less... as low as £22 PM.
What I need to do is increase all rates in a spreadsheet by 10%... but within this take it to a MINIMUM of £30 and not increase the max of £40.
Bit of a newbie question probably.
Thanks for any help.
Sample
<tbody>
</tbody>
I run a subscription club to a club. We are putting in place new pricing, as there is a huge amount of historical prices in there that we need to get back in line.
In summary, the new prices will be £40 per month. Some pay this already, so will hold that rate.. so pay a lot less... as low as £22 PM.
What I need to do is increase all rates in a spreadsheet by 10%... but within this take it to a MINIMUM of £30 and not increase the max of £40.
Bit of a newbie question probably.
Thanks for any help.
Sample
£40 | Keep |
£35 | Increase 10% |
£34 | Increase 10% |
£22 | Increase to Min £30 |
<tbody>
</tbody>