Ron,
Good to see that you made it work.
Here are two suggestions for the future
You only need 1 IF in QuickBase, so you need to undo your excel background.
If(
[Designer]= "Name", [Hours Worked] * 40.9,
[Designer]= "Name", [Hours Worked] * 38.6,
[Designer]= "Name", [Hours Worked] * 34)
But the right way to do this is not to hard code it.
There should be a table of designers and their rates. Then setup a relationship where 1 designer has many rates and pull that down as a lookup field for the Rate.
Then I would set up a snapshot field on that rate lookup
https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html so that you do not change the historical records, when the rates are changed over time.
