Hi,
I was able to recreate your problem by going to Tools/Options/Transition and
putting a check mark in "Transition Formula Evaluation".

Not sure what it does tho.

HTH
JG

"crzyg8r" wrote:

Pete,

By the way one other thing I should have mentioned is that I did check and
verify the the Tools-Options-Calculations is set to automatic as I noticed
that advice on several other related posts.

CG

"Pete" wrote:

It might be a rounding error problem. If you have 1.4 in both A12 and
A13 but these are formatted as number with 0 decimal places, they will
both show as 1, but the answer to the formula will show as 3.

Pete