How do I multiply the result of the INDIRECT function ?

[1up]

I've used the INDIRECT function in Excel 2010 to retrieve the value I want. In this case it is 3.09 in cell E6. However, multiplying or doing any kind of operation with cell E6 returns a #VALUE! error. I tried using VALUE(E6) thinking it was not in number format, but that generates #VALUE! error aswell.

Any ideas on how to solve this is much appreciated.

[1up]

It is solved now. Upon pasting as values I notice a blank character at the end which is causing the error.

I do want my formula still active so I still need to remove that last character some how however.

[zbor]

You can use SUBSTITUTE like:

=A1*SUBSTITUTE(your formula, " ", "")

[Pepe Le Mokko]

Perhaps using the TRIM function?

[1up]

Thanks for the quick answers. I managed to solve it by using the left function.