Hi sorry for the late reply, I've been on holiday.

I'm new to excel so for me it's trial & error.

I'm trying to get the answer in column e3:E8

for row 4
If there is a 0 in column B4 ( no hours carried over from the previous financial year )
& they've had 4 hours of lessons in column C4 but they didn't block book any hours so D4=0, then the answer in column E4 should be 0 but it shows as -4. when I'm wanting the answer to show as a 0

in row 5 the person has no hours carried over from the previous financial year B5, but they have 4 hours of lessons C5 and they've block booked 10 lessons D5 so the remaining block booked hours show as 6 in E6 so that's correct.

I just can't get the answer to show as a 0 in B4 or B6

I don't know how to achieve this

Kind Regards