Excel 2002 - #DIV/0!
Started by
ARO-RS3
, Aug 15 2012 09:29 AM
#1
Posted 15 August 2012 - 09:29 AM
#2
Posted 15 August 2012 - 09:58 AM
Hi,
the message is quite clear, you are dividing by 0. You need to check the content of C8 and make sure it is not 0. Because just about any number divided by 0 will not be 0.
regards myrti
the message is quite clear, you are dividing by 0. You need to check the content of C8 and make sure it is not 0. Because just about any number divided by 0 will not be 0.
regards myrti
#3
Posted 15 August 2012 - 10:07 AM
I want the message to be that if I am dividng my zero that it lists zero. i.e. if all cells are zero and the forumla is =B8/C8*D8*F8 the outcome is zero.
#4
Posted 15 August 2012 - 10:12 AM
Hi,
how about using an if clause? =if(C8=0,0,B8/C8*D8*F8)
regards myrti
how about using an if clause? =if(C8=0,0,B8/C8*D8*F8)
regards myrti
#5
Posted 15 August 2012 - 10:14 AM
Yes that worked. Thanks
#6
Posted 16 August 2012 - 07:09 PM
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users