May 29 2022 12:32 PM
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.
View best response
May 29 2022 12:35 PM
@David_acc
In C2: =MAX(B2-2000,0)
Fill down to C200.
May 29 2022 12:58 PM
View solution in original post