I have downloaded a template stock excel document which is linked to stocks on excel. I am looking for all stock to be in the one currency (GBp) therefore need to convert some USD to GBp and divide some stock in the costing column by 100.
Within the current price column, the current formula is =B6#.Price
B6 is where the stock information held can be found.
I have created a separate workbook with live currency conversions if needed however am unable to access a GBp currency therefore would require a division of 100 of all UK held stocks at this time.
Could anyone offer some advice on this?
Bookmarks