#1   Report Post  
19Eva95 19Eva95 is offline
Junior Member
 
Posts: 0
Smile !ZeroDivide Error

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!
Attached Images
  
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual basic runtime error 5216, there is a printer error [email protected] Microsoft Word Help 2 June 6th 18 08:53 PM
Is this an application error, graphic error or stupid error. Sissi Microsoft Word Help 1 October 31st 08 08:03 AM
docvariable when empty gives error - how to stop error text in doc justagrunt Mailmerge 1 February 21st 07 04:52 AM
Word 2003 - when closing receive 'Runtime Error 91' error messages RLC Web Microsoft Word Help 1 January 11th 06 06:16 AM
MVB error- compile error method or data member not found jvb70 Microsoft Word Help 0 July 29th 05 05:39 PM


All times are GMT +1. The time now is 04:51 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"