help with calulation
Hello. I am trying to set up a payroll calulation field and i need help. Basically what i want is a field that will return the payout of a rep based on if their base pay is greater than their commission it will return what their base pay is, but if their commison is greater than their base pay it will return their commssion.
ok, first i have 50 fields called DBA 01 - 50. Each DBA field = $14 depending on how many company names i put it. EX: 1 DBA = $14 while 7 DBA = $98 (14*7)
second, i have a field called Commission that mulitpies each DBA field by $14 giving me an estiment on payroll.
lastly, i have a field called Base Pay that mulipies whatever hours i put in by 7.25
Now i have a field called Pay out and ive tried this: If ( Base Pay > Commission; Base Pay or If (Commsion > Base Pay; Commsion) ) but it doesnt return what i want. I hve also tried this 3 different way but still nothing works...
what am i missing?