# Fields multiply

Topic Labels: Formulas
Solved
520 2
cancel
Showing results for
Did you mean:
6 - Interface Innovator

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

1 Solution

Accepted Solutions
7 - App Architect

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!

2 Replies 2
7 - App Architect

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!

18 - Pluto

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