Excel Numbers to Text & Percentages in Formulas

[elisagarrett]

I need to change text to numbers in Excel and use it later in a formula. For example, everytime a T is shown in a column, $6.50 is added into the formula or B is $7.50. Also, when I type in a formula with percentages such as, C2+6.5%+55%+$6.50(This is the T, I asked about earlier)the answer is wrong. In this case C2 is $5.83 and Excel calculates this as $12.945 instead of $16.12. Any suggestions?

 

[Yogi Anand]

On 2002-09-29 09:45, elisagarrett wrote:
I need to change text to numbers in Excel and use it later in a formula. For example, everytime a T is shown in a column, $6.50 is added into the formula or B is $7.50. Also, when I type in a formula with percentages such as, C2+6.5%+55%+$6.50(This is the T, I asked about earlier)the answer is wrong. In this case C2 is $5.83 and Excel calculates this as $12.945 instead of $16.12. Any suggestions?

Hi Elisa:

Welcome to the Board!

Elisa 5.83+6.5%+55%+6.5 does come out to $12.95

Perhaps you are trying to compute:
=5.83+6.5+55%+6.5 -- that will compute to $19.38

see the worksheet simulation ...

y020929.xls
	B	C	D	E	F
1
2		5.83
3
4		$12.95		$19.38
5
Sheet12

</SPAN>

Regards!

Yogi

 

[Dave Patton]

On 2002-09-29 09:45, elisagarrett wrote:
I need to change text to numbers in Excel and use it later in a formula. For example, everytime a T is shown in a column, $6.50 is added into the formula or B is $7.50. Also, when I type in a formula with percentages such as, C2+6.5%+55%+$6.50(This is the T, I asked about earlier)the answer is wrong. In this case C2 is $5.83 and Excel calculates this as $12.945 instead of $16.12. Any suggestions?

I could be missing a lot of information so I will make some assumptions.

You use code for a variety of values.
You could access this information with
If, Vlookup, Lookup, Hlookup, Choose etc.

The Lookup information could be in the formula or refer to a range. I named a range
(LookupV) with the letters in one column and the values in the next.

=(C2+6.5%*C2)*1.55+LOOKUP(B2,LookupV)