setting up google sheets

intertan

Member
Nov 8, 2014
81
36
58
I am setting up google sheets to keep track of my dash. I need some help
I need to convert the # of dash I have to USD I have both the amount of dash I have and the current price. Now if I do the simple =a1*a2 I get an error. I believe since I have an actual dolar amount that is the issue
2nd issue is I am also dealing with CAD How can I find out the current CAD amount?
 

intertan

Member
Nov 8, 2014
81
36
58
got the conversion thing sorted now to figure out the first part
The current dash is updated automatically. From there I need to multiply the number of dash I have
$ 3.00* 115
A1 $ 3.00
A2 115