Excel

[David_acc]

I have on an excel sheet, it's like this, from b2 to b200 the payroll amount of 199 workers, I want on c2 to c200 the amount of payroll that exceeds $2000, how do I do that.

[#2 · Accepted solution]

@David_acc 

In C2: =MAX(B2-2000,0)

Fill down to C200.

[#3]

Thanks!! worked