Most valuable professional
  • Hot Topics

Excel Formula returns text that I cannot sum and cannot convert to number.

Hello, I have a formula using CONCATENATE because I have more than 7 nested ifs. This formula returns the right answer but I cannot sum the result of the formula. The answer returns in text and I don't know how to convert it to a number. I tried replacing all the "" in the FALSE part of the if functions but that did not do it. Thanks for any comments. Formula below.

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of August 17, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel