That's right, I lost the last parenthesis when copy-pasting, my bad.
--
Anne Murray


"David Biddulph" wrote:

The 2nd formula isn't legal. The parentheses don't match, so you shouldn't
have been able to get an answer. I don't know how you changed it to get an
answer, but it should just have an extra closing parenthesis at the end, so
that the syntax loks the same as the first formula.
--
David Biddulph

"Mattymoo" wrote in message
...
Thank you for your help. It works perfectly for the first column, but
when i
put 185 points in to test the second column I get a return of 'false'
instead of 75.25

"FinRazel" wrote:

Try this:
If A is your points column, pase this formula in column B:

=IF(A1<=60,0,IF(AND(A160,A1<=150),(2.1*(A1-60)),(2.1*90)))

This will calculate your point bonus between 60 and 150 points.
For the next column, modify the formula so it reads:

=IF(A1<=150,0,IF(AND(A1150,A1<=175),(2.15*(A1-150)),(2.15*25))

Notice that I've just changed the numbers to reflect the point bonus
between
150 and 175 points. Do the same thing for the next colum, Change your
starting and ending values, and the pound bonus.

-- Anne Murray