Formula

R

Ransom

Hello everyone,
I am attempting find out how Excel can convert a number into a dollar
amount. For example, I would like to have the number 1 = $25 - 2= $50 and 3=
$150 so that when i put it in the sheet it can automatically total it.

Is this possible?

thanks
 
C

Carim

Hi,

Create your reference in a table and use vlookup() function
a1 = 1 a2 = 2 a3 = 3
b1 = 25 b2 = 50 b3 = 150

then if you input 1 in cell C1, you can have in cell D1 :
=vlookup(c1,a1:b3,2)

HTH
Cheers
Carim
 
Top