Hi, Why do I get this #DIV/0! in my formular cell? How do we fix this problem? Thanks
K kimme Sep 9, 2004 #1 Hi, Why do I get this #DIV/0! in my formular cell? How do we fix this problem? Thanks
F Frank Kabel Sep 9, 2004 #2 Hi probably as you're dividing a number with zero Please post your formula
L Lady Layla Sep 9, 2004 #3 You get this when you try to divide by 0. This can be fixed by using a simple IF formula =IF(cell address =0,0,your formula) : Hi, : Why do I get this #DIV/0! in my formular cell? : How do we fix this problem? : Thanks
You get this when you try to divide by 0. This can be fixed by using a simple IF formula =IF(cell address =0,0,your formula) : Hi, : Why do I get this #DIV/0! in my formular cell? : How do we fix this problem? : Thanks