Dividing a positive and negative value giving #div/0 answer

[NICKRENN]

Hi all

I have a weird problem that seems to only be affecting a new work book.

The formula is the following =(sum(A2:C2))/(D2-(sum(A2:C2)))

A2 = 0
B2 = 1
C2 = 1
D2 = 1

So in effect you have =2/(1-2) or 2/-1 - my results are being shown as a % and so this should show a negative % answer but i'm getting #DIV/0 ?

Does anyone have any tips for things i can look for, bugs, formatting issues, number errors anything

I made a copy of a previous workbook and this formula works in the other one just not this one.

Thanks in advance.

Nick

 

[FormR]

Does anyone have any tips for things i can look for, bugs, formatting issues, number errors anything

Hi, welcome to the board!

Maybe a couple things to get you started:

1. Check that those values are proper numbers and not text that looks like numbers : i.e. =COUNT(A2:C2) should return 4
2. Check that the values are really what you expect : i.e. =COUNTIF(B2:D2,1) should return 3 and =A2=0 should return TRUE

 

[NICKRENN]

thank you so much! i went though a process of elimination found C2 which was pull its number from another data set was showing a 0 using =count

In the data set which was a converted CSV file the numbers were stored as text so, even if C2 was a number it was being read as text from the other sheet.

i have now converted them all and it works again!

Thanks

 

[FormR]

i have now converted them all and it works again!

Great, good to hear