Error #DIV/0!

[dingdang]

Below value is in B6 from U6 as below and formula is V2 , due to 0 divided by value getting error in as #DIV/0! in V2

5 4 1 0 2 0 0 0 15 0 3 0 3 0 0 0 2 2 0 0 #DIV/0!


formula in V6 as below, Pls help

=(C6/B6*10)+(E6/D6*10)+(G6/F6*10)+(I6/H6*10)+(K6/J6*15)+(M6/L6*15)+(O6/N6*10)+(Q6/P6*10)+(S6/R6*5)+(U6/T6*5)

[LaffyAffy13]

H6, P6, and T6 all have values of 0. You can't divide something by 0; that is impossible.

[XOR LX]

Hi,

I believe that at least three of your fractions in that formula currently have denominators equal to zero (cells H6, P6 and T6), and, since division by zero is not defined mathematically, your resulting formula will be in error.

Regards

[dingdang]

any other option ??

[XOR LX]

Depends. What would you like to be returned in those cases where you have division by 0?

Regards

[Sam Capricci]

Ignore post, this can't be what you were looking for.

[Sam Capricci]

XOR, not trying to hijack your post, was working on it when i saw you all posted.

[Sam Capricci]

how about trying this one...
=IFERROR(C44/B44*10,0)+IFERROR(E44/D44*10,0)+IFERROR(G44/F44*10,0)+IFERROR(I44/H44*10,0)+IFERROR(K44/J44*15,0)+IFERROR(M44/L44*15,0)+IFERROR(O44/N44*10,0)+IFERROR(Q44/P44*10,0)+IFERROR(S44/R44*5,0)+IFERROR(U44/T44*5,0)
I'm sure there is a better more concise way to write it but this one worked for me by returning 13 from your data. (and I put your numbers in row 44).

[LaffyAffy13]

dingdang,

You need to change the values in H6, P6, and T6 to something other than 0. Do your columns B through U all have values like your example above, with 0's? In other words, are you receiving "#DIV/0" elsewhere, as well?

[LaffyAffy13]

Sambo kid's response should work for you. It takes any cell with an error and just replaces the error with a value of 0. Here is an edited version to match your question. All credit goes to Sambo kid.
=IFERROR(C6/B6*10,0)+IFERROR(E6/D6*10,0)+IFERROR(G6/F6*10,0)+IFERROR(I6/H6*10,0)+IFERROR(K6/J6*15,0)+IFERROR(M6/L6*15,0)+IFERROR(O6/N6*10,0)+IFERROR(Q6/P6*10,0)+IFERROR(S6/R6*5,0)+IFERROR(U6/T6*5,0)

[Sam Capricci]

Thanks LA13 for the credit. Also wasn't trying to hijack your work either, as I noted I was working on it when you and XOR LX posted.
But there has to be a more elegant way to write that.

[dingdang]

yes!! its work..

Many thanks sambo kid and LA13

[Sam Capricci]

Cool, don't forget to mark as solved then.
And any rep points for all who helped you are always appreciated.