Hi all,
I am trying to calculate the average of the following which is text in my excel worksheet:
Cell A1 has >=$1M and <$2M
I have used the substitution formula to remove the >= and < and $.
So now I am left with this:
1M and 2M
Is there a way to convert the 1M and 2M into 1,000,000 and 2,000,000 and take the average.
So it would equal 1,500,000.
Just thought somebody would have done this before.
Thanks for any help in advance
Mark
I am trying to calculate the average of the following which is text in my excel worksheet:
Cell A1 has >=$1M and <$2M
I have used the substitution formula to remove the >= and < and $.
So now I am left with this:
1M and 2M
Is there a way to convert the 1M and 2M into 1,000,000 and 2,000,000 and take the average.
So it would equal 1,500,000.
Just thought somebody would have done this before.
Thanks for any help in advance
Mark