No output for nested if

  • Resolved gorahul

    (@gorahul)


    1 year, 11 months ago

    Hi there,

    i am using nested if in my calculation, but no output. kindly let me know where i am going wrong.

    =IF(fieldname14<=250000,0,IF(fieldname14<=500000,((fieldname14-250000)5%),IF(fieldname14<=1000000,(12500+(fieldname14-500000)20%),((112500+(fieldname14-1000000)*30%)))))

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @gorahul

    Thank you very much for using our plugin.

    Our plugin is not precisely an Excel interpreter. So, the formulas are not the same. Also, you cannot omit operators like (*).

    The correct equation would be:

    IF(fieldname14 <= 250000, 0, IF(fieldname14 <= 500000, (fieldname14 - 250000) * 0.05, IF(fieldname14 <= 1000000, 12500 + (fieldname14 - 500000) * 0.20, 112500 + (fieldname14 - 1000000) * 0.30)))

    Best regards.

    Thread Starter gorahul

    (@gorahul)

    Thanks for the quick response.:)

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘No output for nested if’ is closed to new replies.