mardi 24 mars 2020

Can someone help in trying to round amounts to a whole number depending on the currency? [closed]

So I have a list of rows which would be going up to row n. The number of rows will be different everytime the macro is run. At the moment, my data populates all the relevant fields and now I have this data starting on row 4. I have the currency column being populated in column C and the amounts being populated in column F.

I am not an expert at creating macros and have been using google to get me this far.

My question is would anyone be able to help in creating a script where if column C contains the currency HUF or JPY then the respective amount under column F would round to zero decimal places? I need this to run from row 4 to row n. Your help is greatly appreciated.

Aucun commentaire:

Enregistrer un commentaire