Cell Number Formatting of Currency Based on Cell Value

JohnTravolski

New Member
Joined
Nov 25, 2015
Messages
39
Office Version
  1. 2019
Platform
  1. Windows
Suppose I have the following:

Bitcoin
฿ 0.00009035​
Ether
Ξ 0.20000000​
Bitcoin
฿ 0.00040000​
Ether
Ξ 0.00600000​
Ether
Ξ 0.01300000​

I can use the following number formatting to insert the corresponding cryptocurrency symbol (Ξ for Ether, for example):

1622532159345.png


What I want is for the currency symbol to be automatically determined by the value in the left cell. In other words, if I changed the cell value from "Ether" to "Bitcoin," I would expect the currency symbol to change from Ξ to ฿. Is this possible? If so, how do you do it?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Sufiyan97

Active Member
Joined
Apr 12, 2019
Messages
462
Office Version
  1. 2013
Platform
  1. Windows
If you are open to use helper column,

Remember results are in text format so you can't use SUM for it

Book2
ABCDEFGHIJKL
1Bitcoin฿ 0.000090350.00009035฿ 0.00009035CurrencyCurrency codeCurrency symbol
2EtherΞ 0.200000000.20000000Ξ 0.20000000Bulgarian levBGNлв
3Bitcoin฿ 0.000400000.00040000฿ 0.00040000Swiss francCHFCHF
4EtherΞ 0.006000000.00600000Ξ 0.00600000Czech korunaCZK
5EtherΞDanish kroneDKKkr
6Dollar1$ 1EuroEUR
7DollarUSD$
8Pounds sterlingGBP£
9Croatian KunaHRKkn
10Georgian lariGEL
11Hungarian forintHUFft
12Norwegian kroneNOKkr
13Polish zlotyPLN
14Russian rubleRUB
15Romanian leuRONlei
16Swedish kronaSEKkr
17Turkish liraTRY
18Ukrainian hryvnaUAH
19Emirati dirhamAEDد.إ
20Israeli shekelILS
21Kenyan shillingKESKsh
22Moroccan dirhamMAD.د.م
23Nigerian nairaNGN
24South african rand**ZARR
25Bitcoin฿
26EtherΞΞ
27
28
29
30
31
32
33
34
35
Sheet1
Cell Formulas
RangeFormula
D1:D6D1=VLOOKUP(A1,$I$1:$K$26,3,0)&" "&C1
 

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,305
Office Version
  1. 2016
Platform
  1. Windows
Try Conditional Formatting.
Select B1
Formula : =A1="Bitcoin"
Set the number format.
Do the same for Ether.
Copy B1 and paste format down as far as you need.
 

Forum statistics

Threads
1,144,161
Messages
5,722,838
Members
422,460
Latest member
VBA_Noob01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top