True and false formula
thnx for the reply it did help me with the false error because indeed it's a
financial structure/frame I'm working.
But I still get the ! telling me it's a inconsistent formula even after I
used the formula suggested by you.
"Peo Sjoblom" wrote:
Most likely there are rounding errors, what are you comparing and how much
of a precision do you need? What values are in H? If they are currencies for
example then you might try
=ROUND(F100/1.82,2)=ROUND(H100,2)
--
Regards,
Peo Sjoblom
"susy" wrote in message
...
Hi my name is susy
I have been using true & false formulas. But every time I use them I get a
! sign argumenting that this formula is different form the other in this
area. this is how I formulated it G100=(F100/1.82)=H100
At the other hand I get a falsE while it should be true using this same
formula G26=(F26)/1.82=H26
1. how can I avoid this?
2. how can I check if the formula have a error?
3. or there are limits for using the ture and false
susy
|