• !ZeroDivide Error

    From 19Eva95@21:1/5 to All on Tue Mar 23 11:34:45 2021
    Hi! I need to calculate the ACoS (Green field) and used the following
    formula
    =(C7/E7)*100
    This works when all fields are above 0, but when E7 is 0, I get the
    error !ZeroDivide.
    If the E7 is 0, I need the outcome to be 0,00%

    How can I fix this?

    Thanks in advance!


    +-------------------------------------------------------------------+ |Filename: Screenshot 2021-03-23 at 12.18.36.jpg | |Download: http://www.wordbanter.com/attachment.php?attachmentid=261| |Filename: Screenshot 2021-03-23 at 12.15.09.jpg | |Download: http://www.wordbanter.com/attachment.php?attachmentid=262| +-------------------------------------------------------------------+



    --
    19Eva95

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)