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
Solved
Fields multiply
+5Best answer by AirOps
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!
+10Hi 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!
+31To 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},
",",
"."
)
)
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.