Skip to main content

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

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!

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},
",",
"."
)
)

Reply


Terms & Conditions