Fields multiply

[Julien_Etoke]

Hello community,

I'm trying to multiply two fields but I get an error message.

Cell 1 : a currency field manually filled like "€100"
Cell 2 : a formula field with number like "10,1"

I want to multiply "10,1" by "€100"

Formula : (cell1) * (cell2)

Do you know why i'm getting an error message ?

Kindly

[AirOps · Accepted solution]

Hi Julien, 

My inclination is that your formula field with a number like "10,1" is being perceived as a string in you new formula. I would check the formatting of your formula containing values with commas to double check it is being perceived as number value. 

If you want a quick fix you can try to encapsulate cell2 by the VALUE( ) function which should recognize 10,1 correctly. Your formula would then become: (cell1)*VALUE(cell2)

Hope this helps!

[TheTimeSavingCo]

To add on to what Cherry said, you may need to modify your original formula to use periods instead of commas.

Alternatively, you could use the following formula as well:

VALUE(
  SUBSTITUTE(
    {Cell 1},
    ",",
    "."
  )
)