i have this formula but its stupid!

=(B3-(IF(B3>2;0.5;0)))+(C3-(IF(C3>2;0.5;0)))+(D3-(IF(D3>2;0.5;0)))+(E3-(IF(E3>2;0.5;0)))

if a formula works, then its not stupid. anything fixing the formula will look similar.

the only problem you will have is when have to expand the formula to column F, g,h and on and on.

copy&paste this

=SUMPRODUCT((B3:E3)*(B3:E3<=2) +((B3:E3)-0.5)*(B3:E3>2))

basically if you need to expand it, then just change all the b3:e3 ranges in the formula.

let me know if it works for you.

i have this formula but its stupid!

=(B3-(IF(B3>2;0.5;0)))+(C3-(IF(C3>2;0.5;0)))+(D3-(IF(D3>2;0.5;0)))+(E3-(IF(E3>2;0.5;0)))