[CLOSED] Excel calculation

Home – SaaS Forums Support questions WooPrice Calculator (Pro) [CLOSED] Excel calculation

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #6126
    Roel Dolhain
    Participant

    Hi,

    Working for hours to set up a simple calculator with an Excel sheet. Doesn’t work for me…

    Excel sheet:
    1 Sticker Monomeer lossnijden
    2 Eenheidsprijs € 25,00
    3 Lengte (in cm) 100
    4 Breedte (in cm) 100
    5 Aantal stuks 1
    6 Totale prijs € 37,00

    Formula: =(B3*B4)/10000*B2*B5+12
    Explanation: B3 and B4 length & width in cm; B2 unit price for a square meter and B5 number. Contour = 12 Euro (+12 at the end). Formula works in the Excel sheet but not anymore when uploaded in WooPrice. Front end price is always 12 Euro so I think it’s not possible to set up a math with for example a discount formula for big surfaces ?

    Please can you take a look ? I’ve sent the admin panel information by e-mail.

    Kind regards,
    Roel

    #6128
    Enrico
    Participant

    Hi Roel,

    I get a password protection for your front-end.

    You can send me the password via email (https://altoswebsolutions.com/contact-us) if you prefer.

    Best regards,
    Enrico

    #6127
    James Nickles
    Participant

    Roel,

    An observation: I’ve noticed that by building my spreadsheets in google drive sheets, then downloading them in Open Document Format (ods) and uploading them in ods format, the calculator excepts the formulas more consistently.

    Best regards,
    : DJ

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.