#Value! Returned ?

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a formula in a cell that returns # value. The formula is
=CONCATENATE(D9," ",E9,F9,)

The Column D is formated to Text and both E and F are General. My problem is
that when I type a value in E9, the #Value! is returned

Any ideas on whats causing this?
 
I've just worked it out, for everyone elses benefit

As I had checked Transition Formula Evaluation and Transition Formula Entry
it caused it.

Not sure why that might be
 
Hi
what exact values are in your cells. also try the following instead:
=D9 & " " & E9 & F9
 
You must log in or register to reply here.

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

Similar Threads

Multiple value if function using dates 2
Timesheet Calculation 8
"IF" confusion 3
excel template for calculating trial balances and adjusting entri. 2
end result 4
I want to display this as the value, not the cell reference. 2
Multiple If (Lookup?) Statement 7
IF Ranges 2

Back
Top