# #DIV/0!

#### ExcelRoy

##### Well-known Member
hello,

i have had a problem that you solved for me earlier in the week, i had the #n/a coming up with uncalculated formula in (looked unprofessional)

i used

=IF(ISNA(INDEX(Supplier!\$C\$5:\$C\$505,MATCH(B6,Supplier!\$A\$5:\$A\$505,0),0)),"",INDEX(Supplier!\$C\$5:\$C\$505,MATCH(B6,Supplier!\$A\$5:\$A\$505,0),0))

to get round problem

now i have same but with #DIV/0! coming up is there a way round this one

kind regards

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

##### MrExcel MVP
hello,

i have had a problem that you solved for me earlier in the week, i had the #n/a coming up with uncalculated formula in (looked unprofessional)

i used

=IF(ISNA(INDEX(Supplier!\$C\$5:\$C\$505,MATCH(B6,Supplier!\$A\$5:\$A\$505,0),0)),"",INDEX(Supplier!\$C\$5:\$C\$505,MATCH(B6,Supplier!\$A\$5:\$A\$505,0),0))

to get round problem

now i have same but with #DIV/0! coming up is there a way round this one

kind regards

What is the formula that comes up with #DIV/0!?

#### ExcelRoy

##### Well-known Member
=SUM(C199*Supplier!I199)

a simple one compared to the last one

thanks

#### gaj104

##### Well-known Member
Hi,

Use the iserror function

Code:
``=IF(ISERROR(C199*Supplier!I199)="TRUE","",(C199*Supplier!I199))``

Hope it helps

#### pgc01

##### MrExcel MVP
Hi ExcelRoy

Why the SUM?

You are just multiplying 2 cells.

=C199*Supplier!I199

PGC

#### barry houdini

##### MrExcel MVP
=SUM(C199*Supplier!I199)

You wouldn't normally expect to get a #DIV/0! error unless you're dividing by zero. I'm not sure how you get that from that formula unless either C199 or supplier!I199 contains a #DIV/0! error. If so you might want to try to prevent that.

If you have a formula like

=A1/B1 then to prevent #DIV/0! errors change to

=IF(B1,A1/B1,0) or similar

note: in the above formula the SUM is redundant, this formula would suffice

=C199*Supplier!I199

#### ExcelRoy

##### Well-known Member
Thanks harry, my formula would read

=IF(G191,F191/G191,0)

thinks shows a value of 0 until i enter the criteria, than it calculates perfectly

But

can you add something to remove the 0, so that it looks more professional

too many 0's showing in a row

#### Richard Schollar

##### MrExcel MVP
Maybe:

=IF(G191,F191/G191,"")

Richard

Replies
3
Views
65
Replies
5
Views
125
Replies
8
Views
107
Replies
3
Views
55
Replies
5
Views
103

1,181,897
Messages
5,932,682
Members
436,850
Latest member
Jasperlee93

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back