Thread: greater than or less than logic

Hi all,

I am fairly new to excel and am trying to figure out how to use logic equations. The company I work for is thinking of changing its payroll formula to include a greater than/less than logic. Basically if the worker's commission is less than the sum of the set hourly wage than they will receive the hourly wage and no commission. But if their commission is greater than the sum of the hourly wage then they will receive the commission and not the hourly wage. We are also interested in comparing how much an hourly wage is likely to cost every week (the difference between the wage and commission if the commission happens to be less than the wage).

This equation will be done daily and payroll is weekly so if possible I would like the sum of the daily equations (greater than or less than) to be added up and displayed in as a weekly total.

In the picture below, hours x10 is the hourly wage and com is commission

excel question.JPG

If this question does not make sense please let me know,
Thanks for the help!