Forum Discussion
reading number of decimal places
Hi all I’m trying to automate some number manipulation, where I am trying to apply a rounding tolerance, e.g. if a number is 1.25, then the tolerance is 1.254 and 1.245. I have used the formula =IF...
Keggsy , further, a safeguard may be added as red font :-
=IF(CELL("format",A14)="G",IF(A14=INT(A14),0,LEN(MID(A14-INT(A14),FIND(".",A14,1),LEN(A14)-FIND(".",A14,1)))),IF(LEFT(CELL("format",A14),1)="F",VALUE(RIGHT(B14,LEN(B14)-1)),"alert!"))
amit_bhola thank you very much, that seems to work. The formulas do need to be manually updated, however they do update automatically when the file is opened, so if it is missed then it will capture it then.
- yeah.. i think workbook is recalculated at file close and open events...
