Decimals adding to a lower number~

[kcrudo]

14.80 is the sum for each quarter, rounds to 15, but when you add 4 quarters it totals 59.20. Problem is the employees see 15 per quarter and expect the total at the end of the year to add to 60. I have even formatted the numbers as whole numbers...

P/S hours = 37
Formula to get the 14.80 - =IF(TODAY>'1/1/2011','P/S HRS',0) Answer: 14.80
Formula to get the 59.20 - =QTR1+QTR2+QTR3+QTR4

Hopfully I have explained it well....

 

[yogeshmaney]

how abt roundup function

 

[barry houdini]

Try using ROUND function to round to an integer, then that converts the result to that integer rather than just displaying as such, so for your Quarter formula use

=ROUND(original_formula,0)

 

[kcrudo]

=Round((IF(TODAY>'1/1/2011','P/S HRS',0))

You'll have to excuse me but the cell errors with this formula

 

[yogeshmaney]

=Round(IF(TODAY>'1/1/2011','P/S HRS',0),0)

 

[barry houdini]

I'm not sure your original formula is valid anyway, what's P/S HRS is that a named cell or range?

You need a zero for the ROUND function 2nd argument as well as a zero in your original, something like

=ROUND(IF(TODAY>DATE(2011,1,1),'P/S HRS',0),0)

 

[kcrudo]

=ROUND(TODAY>'1/1/2011','P/S HRS',0)

Errors with "The function has the wrong number of arguments....

 

[yogeshmaney]

please copy paste the formula given by barry.

 

[kcrudo]

Worked! Thanks so much, formulas are a down fall in my life...

 

[kcrudo]

Thanks Barry!!!!!!!!