Excel Sheet - Payslip

I wanted help to create a simple excel sheet please. I require you create

A Payslip

DETAILS
Name
range of date
Days worked (manually entered)


EARNINGS
1) units x rate = total (automated from name)
2) private earnings (manually eneterd)
3) Payment Plan (number of patients) amount


Deduction
a) Dropdown list category | freetext comment | amount | *for split


Adjusted Earning
50% of (1)
45% of (2) (if (2)/days worked is >£500 then 50% of the amount earned above £500/day)
50% of (a) if it has a *

net earning