Hi all am hoping someone can help me with a formula. Here is an example of what i need. =sum(cell reference *0.18+4.50), what i want to add to the formula is if the number in the cell reference is greater than 500, i want it to add 0.15, instead of 0.18, and if it is greater than a 1000 i want it to add 0.13, instead of 0.18 or 0.15. can anyone help me with this I would appreciate it. Cheers:confused2: