Validation

[Rick Oelkers]

I am trying to use the formula for cell validation in cell B9 on a spread sheet.

=FIND(".",B9,1)>=LEN(B9)-2 if I enter 724.00 or 724 I get an error however if I enter 724.01 I get no error. I do need to enter whole dollar numbers at times. How can I get the validation to work with whole numbers also.

[TMS]

Please Login or Register  to view this content.

will be true if the decimal part is zero. That is, =INT(724.00)=724.00(=724)=TRUE; =INT(724.01)=724.01=FALSE

So, you could test for that first to eliminate whole numbers (integers)

Regards, TMS