Hope I understood your problem.
Let you SUM from cells A1 to A5 and you want to multipy it by 0.25 if it is
greater than 10000, then

=IF(SUM(A1:A5)10000,SUM(A1:A5)*0.25,0))

This would be OK.Remember to substitute A1:A5 with your data range

If your problem is solved,spend time to look at my blog
http://xlmaster.blogspot.com

johndavies wrote:
Hi,

Having a spot of bother here with a formula, what I need if any one can
help is the following

Sum of a number of fields and IF that SUM is than 10000 then * by
0.25

This a mileage workout and it's pulling my hair out.

Thanks in Advance

John