I actually tried that while waiting for further responses - no joy, even
after changing commas to semicolons :(

Seems to me it would be the same as Number with 2 decimal places anyway,
would it not?

That said, I think I've solved this by adding INT in front of my formula:

=INT(MAX(0,40-(SUM(N7:N13))-SUM(S7:V13))+MAX(0,40-(SUM(N14:N20))-SUM
(S14:V20)))

--
David

Barrett9699 wrote


Oops. Sorry! Try this one:

0.00, -0.00, ""

I tested is this time, and I think it's exactly what you want. Let me
know if it's not.