This works correctly for me as well. I don't know why it isn't working for
you, but heres some things to try.

Retype the number 235 in G43. If originally entered as text, changing
format to number may not change it until retyped.

What happens if you enter a number greater than 300? Does "OK" or "NG" show
up? What about other numbers? Does it ever change?

Do you have any Macros or VB code in your workbook? I have myself stopped
using code before, then forgotten about it, until weird results started
showing up later.

Recreate this in a new workbook and see what happens. If it works, this may
give you an indication whether it is an Excel setting, or a Workbook setting
that is causing the problem.

HTH,
Elkar


"A. Blundon" wrote:

Calculation is set to automatic. Also I tried hiting F9 a so see if it
would recalc. Still no luck.

Thanks,
AB