R
Ray Hasson
I'm trying to use validation to check an input value
against a pre-computed total. The validation is set so
that the input cell equals the "sum" cell.
The cells providing the sum contain formulas but only
one cell appears to be causing my problem, if I enter the
formula results directly into the cell overwriting the
formula validation works.
The formula does not contain circular references and
is a simple time-value of money calculation. Where (C7*
(E16*(C9/365)) C7 equals present value, E16 equals number
of days and C9 is the dividend rate.
Does anyone know why the formula produces an accurate
result but validation won't work with it? The formula in
the next cell down is an IF function and doesn't create a
problem, so it's not just that it's a formula...
against a pre-computed total. The validation is set so
that the input cell equals the "sum" cell.
The cells providing the sum contain formulas but only
one cell appears to be causing my problem, if I enter the
formula results directly into the cell overwriting the
formula validation works.
The formula does not contain circular references and
is a simple time-value of money calculation. Where (C7*
(E16*(C9/365)) C7 equals present value, E16 equals number
of days and C9 is the dividend rate.
Does anyone know why the formula produces an accurate
result but validation won't work with it? The formula in
the next cell down is an IF function and doesn't create a
problem, so it's not just that it's a formula...