Thread: Why, please?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
an an is offline
external usenet poster
 
Posts: 37
Default Why, please?

Ok, GS.

Work fine with =ROUND(SUM(xx;xx);06)

Thank you very much for your help.
an


"Gary''s Student" wrote:

It's probably simple round-off error. Use the ROUND() function to force a
precise result.
--
Gary''s Student - gsnu200795


"an" wrote:

Hi!

Excel 2007.

In Conditional Formating I have a formulae =$U3<MONTH(TODAY())*$H3.
I apply this formulae to =$U119<MONTH(TODAY())*$H119.

Work fine except on the Col 'U' there are 6 unduly collored cells.
If I add 0,0000000000001 to each cell, those cells change to not collered.

This is a bug, please?
Thanks in advance.
an