I am curious to know what this Lotus123 compatibility is? and what is
this transition formula evaluation?

On Jul 5, 11:37 am, Mahadevan Swamy wrote:
Thanks a lot for your solution. :)

On Jul 5, 11:27 am, Dave Peterson wrote:

Your friend has a Lotus 123 compatibility setting toggled on:

Tools|options|Transition tab|Transition formula evaluation
is not checked for you and it is checked for him.

I don't use Lotus 123 and don't want any of those options checked.

If I didn't want to see the #value error, I'd either hide it with:
Format|Conditional formatting

a check in the formula:
=if(isnumber(b15),(2^12)*b15,0)

or use a different formula:
=(2^12)*N(B15)

====
Yep, I added ()'s. I find that they make it easier for me to read--I don't have
to rely on or remember the order of precedence.

Mahadevan Swamy wrote:

When I go to a cell a type the formula: = 2^12*B15 , it reports a
#VALUE error. B15 is a text value.

When I look at my friend's workbook, he has written the same formula
and it reports 0. How can I do this? I have checked my number formats
and changed it to special but still it is not solving the problem.

How can I solve this problem?

Thanks in advance.

Swamy

--

Dave Peterson