Very Peculiar DV error Q
Just an update on this, I think I have a formula that does what I
require, it tests for
a) There is a value in J10
b) H10 as entered is <=0.01 and =40000.00
c) The user only inputs a max of 2 decimals (I test that the length of
H10 - to the right of the decimal, is no longer than 2 - if user only
enters a whole number it returns 0, thus a length of 1 i.e. still
valid as an entry)
=AND(J10<"",H10=0.01,H10<=40000,LEN((IF(ISERROR( RIGHT(H10,LEN(H10)-
FIND(".",H10))),0,RIGHT(H10,LEN(H10)-FIND(".",H10)))))<=2)
|