Total : 0.00 €

Before contacting us, please make sure to check our F.A.Q

Please, login or register to our website in order to be able to post a presale question in the forum.

# Text field * Numberic field

10 months 4 days ago #2577 by David Boyle
David Boyle replied the topic: Text field * Numberic field
Hello Ismail,
have you tried to use the excel function Len() ?
www.got-it.ai/solutions/excel-chat/excel...-characters-in-excel

Use this function to get the number of the characters in the text and then use that number to multiply with the price.
David
at2039

Please Log in or Create an account to join the conversation.

10 months 1 week ago #2572 by Ismail
Ismail created the topic: Text field * Numberic field
Hello, I am new to woo price calculator and I need help creating the formula for my website. I have 2 fields that needs to be calculated, 1 of them is a text field. Every letter has a standard price. That is 1,50 euros. The numberic field has a minimum value of 3 and a maximum value of 100. I need to make this formula:
For example:
Height: 3
Test are 4 letters. So that will be 4*1,50 euros= 6 euros.
6 Euros * Height of 3 is = 18
After this formula, I need to do 18*0,25 and that is the last price.
So the total needs to be: 4,50 euros.
I have already created 2 fields. 1 For the text and the other one for the height. But, I tried so many things in the formula, and I just couldn't get it to work..