[SOLVED] field check in formula

Home – SaaS Forums Support questions WooPrice Calculator (Pro) [SOLVED] field check in formula

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #5556
    yueming chen
    Participant

    hi, I get some problem with the formula. I upload my xlsx but it didn’t show anything so I change to the calculator.

    I input two fields(height/width) that 800(mm) and 1300(mm).I want to check If height or width smaller than 1000(mm), the calculator would default(1000) in the formula.

    i.e output_price: if(aws_c<1000?1000:aws_c)

    #5557
    Paul
    Participant

    Hello,
    Could you attach your excel to verify your problem?
    The condition statements are not available in the mathematical formula section. You need the excel.
    you can solve this with excel formula: IF(aws_c<1000;1000;aws_c).
    Best Regards,
    Paul
    AT445

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