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 |
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 |
All times are GMT +1. The time now is 01:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com