#Value! Returned ?
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 "John" wrote in message ... 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? |
Hi
what exact values are in your cells. also try the following instead: =D9 & " " & E9 & F9 -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... 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? |
All times are GMT +1. The time now is 12:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com