Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |