Bonuses On Excel, Formula Help, Ocr Nationals?

Hello, I need to figure out bonuses for some total incomes. Here is the information I have:
Show the bonuses given to staff based on the total income each year. These bonuses are to help them sell more:
£0.00 Nothing
£200,000.00 £50 shopping vouchers
£250,000.00 Trip to London for Christmas shopping
£300,000.00 Trip to Paris for Christmas shopping
£350,000.00 Trip to New York for Christmas shopping
I have all the total incomes worked out for each year (2004-2008) but I am stumped to what the formula would be.
It is telling me that if the total income is bigger than the figure on the left, it gets the bonus on the right but I do not know the formula to do this.
Thanks in advance,
Megan

Both comments and pings are currently closed.

Comments are closed.

Powered by WordPress | Designed by: free css template | Thanks to hostgator coupon and web hosting reviews