#VALUE error
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
|