(while I'm waiting for my answer, thought I would respond to yours)

I would use 4 seperate cells, one for each portion, and then a cell that
totals them.

You can always hide the 3 cells you dont want, or put them on another tab.

Otherwise you would need to use a function or subroutine / macro code to do
that.

-phil

"Dale" wrote:

I have written a function with 3 IF statements for a tiered commission
calculation; is there any way to have the function result include all 3 IF
statement results as a sum?