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

1 month 5 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

1 month 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..