Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
David_accCopper ContributorMay 29, 2022SolvedExcelI 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.HansVogelaarMay 29, 2022David_acc In C2: =MAX(B2-2000,0) Fill down to C200.
HansVogelaarMVPMay 29, 2022David_acc In C2: =MAX(B2-2000,0) Fill down to C200.David_accCopper Contributor to HansVogelaarMay 29, 2022Thanks!! worked