Formula value does not show-"error-constant in formula"

G

GC

I can't fix a simple Concatenate formula that won't display it's result
(tried turning Formula Auditting mode on & off).

When I do an "Evaluate Formula" on the cells that formulas are not
displaying values in I get the following
error: The cell currently being evaluated contains a constant".

The formual looks identical to ones in cells above and below (except for
cell #'s that do work fine.
The data referenced in the formula looks fine.

This one works:

=CONCATENATE("SHOULDER BOLT ", A6," DIA X ",B6," L X ",H6,)



This one doesn't:
=CONCATENATE("SHOULDER BOLT ",A12," DIA X ",B12," L X ",H12,)


How can I fix this problem?

Gary
 
D

Dave Peterson

They both worked ok for me.

What does the second one evaluate to?

Maybe you have tools|options|calculation tab|set to manual????

Maybe the cell is formatted as text???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top