VBA for userform to input into table

see big yellow banner - how to upload your workbook - get help relevant to your case.
attached a simple demo form - needs very little alteration to accommodate more data.
add a few extra columns to the table - alter a few variables in the code - keep the default names of textboxes and labels - let the code do the work.
far better to have your formula controlled by the code - less sheet errors and less maintenance.