Hi,

Without knowing the cell references I would guess that the formual you
are after would be something along the lines of

=if(sum of fields10000,sum of fields * 0.25,sum of fields)

Hope this helps

Regards

Carl

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



--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=570693