Talk:Documentation/Calc Functions/EFFECT ADD

    From The Document Foundation Wiki

    SF Comments

    (1) General. This function is similar to EFFECT. Please apply relevant comments on EFFECT to this page.
    (2) General. It is important to highlight the difference between EFFECT and EFFECT_ADD. This hinges on the formatting of the result; EFFECT defaults to formatting as a percentage, while EFFECT_ADD defaults to formatting as a number.
    (3) General. Please mention that if you save a Calc file that contains calls to the EFFECT_ADD function into Excel format, those function calls are converted to EFFECT in the Excel file.

    --Stevefanning (talk) 2020-11-18T14:11:27 (UTC)