Formula with total greater than so many hrs

  • Thread starter Thread starter Rob F
  • Start date Start date
R

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.
 
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
 
Back
Top