In Crystals 2010, I need to make the following forumla field.

 

I am very junior, your help is much appreciated!

 

I have a sum field (where I have asked it to sum up a coloumn of numbers)

 

I would like this formula to look at the sum field and determine the following..

 

 

if less than 15,000 calculate 11% of sumfield

If greater than or equal to 15,001 and less than or equal to 30K calculate 1650+Sumfield*.23

If greater than or equal to 30,001 and less than or equal to 60,000K calculate 5100+sumfield*.35

If greater than 60,000k calculate 15600 +sumfield*.40

 

 

Please help!

Cheers,
Carrie