IF Formala Doesn't Work
Make sure, then, that G43 is formatted as General. If it is text, it will
give you the result you have. Set the format and then re-enter 235.
AndyB
"A. Blundon" wrote in message
oups.com...
Calculation is set to automatic. Also I tried hiting F9 a so see if it
would recalc. Still no luck.
Thanks,
AB
|