Hi
I need help with formula
So I have a spreadsheet, example
A1 heading- Minimum number of tasks
A2 '5'
B1 heading- Actual completed
B2 '6'
C1 heading- Total incl over achievement
C2 6.5
I want a formula which adds 0.5 for every 1 added over the minimum (but the minimum may change in the...