Sage 50 Payroll Upload Problem

[suma]

Hi,

I am in the process of developing an excel upload into Sage 50 Payroll, but have hit a snag.

If someone works less than their contracted hours, the upload generates a negative value.

I need excel to return a zero value instead of a negative one, without altering the original formula from working when someone goes over their hours.

I have attached a sample for your reference, and highlighted problem cells in blue. I hope someone can help.

Many Thanks,

Sue