Numbers income tax in column only after a cumulative base amount reached
I'm trying to make a formula to reflect a 6% tax rate of a monthly salary only after a cumulative total has been reached on a month by month basis.
So column A is monthly salary. Column B accumulative total. Column C I want to reflect 6% of the monthly salary after column B reaches 10,000.
This is a company cost spreadsheet not an individuals accumulation so if a new person started in the same position the cumulative would revert to zero. Likewise if a person moved position their accumulation to date would transfer with them.
All this to say I believe the only way to construct the function is to reference cells in the same row. I am used to making hidden columns to extend the logic of the functions but can't get my head around how to express this sum as a function. That is Cx =6% of any portion of Ax only when Bx is over 10,000.
MacBook Pro 16″, macOS 13.5