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)