IF Else Fomula

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #4534
    Steven Smith
    Participant

    Hi

    As i am new here, I am trying to get working on length price so I am looking for if else statement but i cannot find it on the document or forum,

    here is sample

    <1000mm
    €465.00

    <1500mm
    €550.00

    <2000mm
    €640.00

    I'm trying to get it working as i could not able to working if i type under 1000mm like '757' and the price appear 465 euro, if i type over 1000m then the price appear 550

    I have wrote down code but all failed
    this is one example that i failed

    =IF($aws_price_calc_1<1000,"465",IF($aws_price_calc_1<1500,"550"))

    Any Advice would be great

    #4539
    Naidi
    Participant

    Hi Steven,

    you are currently using the free version, that is capable of only simple calculations.
    To be able to use IF formula or even more complicated one, you must use excel files.
    This is something you can achieve only with the PRO version.
    Here is a link of some related real world cases, where you can see some examples how it work: https://altoswebsolutions.com/live-demo/best-cases.
    If you buy the PRO version you will profit of our free support as well.

    Let me know if you have more questions.

    Best regards,
    Naidi Shuli
    AT740

    #4538
    Steven Smith
    Participant

    Hi

    Thank for your email, Now i understand, that reason i am using free version as i didnt want buy it first place if it wont work or waste money. so i will upgrade it to pro version.

    #4537
    Naidi
    Participant

    Hi Steven,

    I wanted to add that the PRO version has the policy of 30 days money-back guarantee.
    Anyway let me know if you have more questions. If you go PRO you will profit our free support , so you can write us for any problem that you might have.

    Best regards,
    Naidi Shuli
    AT740

    #4536
    Steven Smith
    Participant

    Hi

    Thank for your message sorry for not get back to you , i wonder about pro as you mention “up to 3 websites ” at the moment i dont need it, i just need it just one website, as it would be waste for just 3 websites, it’s possible can i get it for just one website?

    #4535
    Naidi
    Participant

    Hi Steven,

    the price of the PRO version is standard and it includes support up to 3 websites.
    So If you purchase it now , you can use it for just the one site you have and than if later you will need for other sites you can use it too(up to 3 sites).

    Best regards,
    Naidi
    AT740

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