Adding increments over minimum number

[BradleyN1]

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 future so can it be set to A2 rather than a '5' number)

So if 6 completed i'd have a total score of 6.5, 7 it'd be 8
However, is it also possible that IF the actual is only 4 (under the minimum) the total would remain as 4? (with no 0.5 added)

Thanks

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Min​

[/td][td="bgcolor:#F3F3F3"]

Comp​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

1​

[/td][td]

6​

[/td][td="bgcolor:#CCFFCC"]

3.5​

[/td][td="bgcolor:#CCFFCC"]C2: =MAX(A2, AVERAGE(A2:B2))[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

7​

[/td][td]

3​

[/td][td="bgcolor:#CCFFCC"]

7.0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

5​

[/td][td]

8​

[/td][td="bgcolor:#CCFFCC"]

6.5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

8​

[/td][td]

4​

[/td][td="bgcolor:#CCFFCC"]

8.0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]

9​

[/td][td]

7​

[/td][td="bgcolor:#CCFFCC"]

9.0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]

3​

[/td][td]

8​

[/td][td="bgcolor:#CCFFCC"]

5.5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]

6​

[/td][td]

7​

[/td][td="bgcolor:#CCFFCC"]

6.5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td]

3​

[/td][td]

6​

[/td][td="bgcolor:#CCFFCC"]

4.5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

10​

[/td][td]

2​

[/td][td]

9​

[/td][td="bgcolor:#CCFFCC"]

5.5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

11​

[/td][td]

9​

[/td][td]

6​

[/td][td="bgcolor:#CCFFCC"]

9.0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

12​

[/td][td]

6​

[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

6.0​

[/td][td][/td][/tr]
[/table]