Formula with total greater than so many hrs

[Rob F]

I have a payroll sheet with a box that needs to calculate how many hours over
106. without showing a negative balance. If its under the 106 I would like it
just to say 0 or leave it blank. I have this formula

=sum(Y11:Y12)-106

this gives me a negative balance if the sum doesn't reach 106 hrs. I tried
using a greater than sign but comes up with error. Thanks for any help.

 

[Don Guillett]

Look at MIN or FLOOR functions

 

[Mick Mekkelsen]

try
=if(sumY11:Y12)>106,sum(Y11:y12),"")



Rob F wrote:

Formula with total greater than so many hrs
07-Oct-09

I have a payroll sheet with a box that needs to calculate how many hours over
106. without showing a negative balance. If its under the 106 I would like it
just to say 0 or leave it blank. I have this formula

=sum(Y11:Y12)-106

this gives me a negative balance if the sum doesn't reach 106 hrs. I tried
using a greater than sign but comes up with error. Thanks for any help.

EggHeadCafe - Software Developer Portal of Choice
Encryption On Mobile Devices in C# / .NET
http://www.eggheadcafe.com/tutorial...0-da5581fdf86b/encryption-on-mobile-devi.aspx

 

[Bernd P]

Hello,

=MAX(0,SUM(Y11:Y12)-106)

Regards,
Bernd