Systems and methods for setting up dynamic calculations within compensation software are described in the present disclosure. According to one embodiment among many, a compensation module for managing compensation for a number of employees includes a dynamic calculation set-up module allowing a user to set up a dynamic calculation. The dynamic calculation includes a calculation for one column of a worksheet based in part on a value in another column. The compensation module also includes a condition builder allowing a user to enter a condition and a result as part of a dynamic calculation. In particular, a column associated with the result receives a calculated value when the condition is met.