Excel 2007 : suppressing #DIV/0! WITHOUT USING THE IF FUNCTION

**Solihull** · 03-13-2011, 06:08 PM

Can anyone suggest how to suppress the #DIV/0! error WITHOUT USING THE IF FUNCTION Many thanks for helping.

**daddylonglegs** · 03-13-2011, 06:18 PM

Try using IFERROR, e.g.

=IFERROR(your_formula,"")

**Solihull** · 03-13-2011, 06:22 PM

Originally Posted by daddylonglegs

Try using IFERROR, e.g.

=IFERROR(your_formula,"")

Hi and thanks for your suggestion - I'm sorry but I didn't make myself as clear as I should have done - All conditional functions are out as the software in which the spreadsheet will be iused does not support conditional processing.

Once again I'm sorry to have been vague - it's late

**daddylonglegs** · 03-13-2011, 06:29 PM

OK, but you might have to give more details - which function or formula returns #DIV/0! and what sort of variables does it have?

**Solihull** · 03-13-2011, 06:37 PM

Originally Posted by daddylonglegs

OK, but you might have to give more details - which function or formula returns #DIV/0! and what sort of variables does it have?

Contents of Cell A1 are 0
Contents of Cell B1 are 100
Contents of Cell C1 are =B1/A1
This results in C1 displaying #DIV/0!
I appreciate that for C1 one would normally use if(A1=0,0,B1/A1) but as I'm not allowed to use conditional processing of any kind it's a challenge.