#Div/0 Error, but not dividing in formula

**tiff58** · 09-23-2011, 02:12 PM

I am receiving a #Div/0 error, but there is no division in my formula, nor in any of the fields that make up my formula. Can anyone assist?

My formula is below:

=IF($D675="TL",($AZ675*1+Inputs!C$21),IF(AND($D675="Rail",$K675="Pine Bluff"),$AZ675*(1+Inputs!C$24),IF(AND($D675="Rail",OR($K675="Canton",$K675="Waynesville")),$AZ675*(1+Inputs!C$22),IF($D675="Ocean",'2012_Budget_Detail'!AN337*(Inputs!C$20+$AZ675),0))))

**daddylonglegs** · 09-23-2011, 02:18 PM

Are you certain there are no #DIV/0! errors somewhere in those cells - that would be my guess.

Do you know what part of the calculation is expected to be performed specifically given the value in the referenced cells - perhaps you can narrow down the search......

Can you attach the workbook?

**shg** · 09-23-2011, 02:23 PM

Try using the Evaluate Formula button to see where it's coming from.

**daddylonglegs** · 09-23-2011, 02:26 PM

Originally Posted by shg

Try using the Evaluate Formula button to see where it's coming from.

mmm.....why would you want to do that when there are much more difficult ways to do it?

**shg** · 09-23-2011, 02:55 PM

why would you want to do that when there are much more difficult ways to do it?

That's my standard thought when I see one of your formulas, dll.

**Winon** · 10-01-2011, 10:17 PM

Now that was absolutely BRILLIANT ddl and SHG ! I really enjoyed you "growling" at each other. ie:
ddl: "mmm.....why would you want to do that when there are much more difficult ways to do it?"
SHG: "That's my standard thought when I see one of your formulas, dll."
I just love it !