=if(a1<80,0,if(a1100,(a1-100)*2+100,a1))

Regards,
Fred

"Jeremy" wrote in message
...
I need to set up a formula that allows the following:

79 or less = 0
80=80
81=81
82=82
100=100
101=102
102=104
103=106
104=108
105=110

Can anyone help?

Thanks