Getting #DIV/O. Can't find a solution
The following formula is returning a #DIV/0 error
=TEXT(ROUND(J37/C37,1),"0.0")&" : 1"
I have tried to use an "IF" formula on it but to no avail. I think it might
be that i am not putting the "IF" formula in the wrong place.
It also appears later in the speadsheet here is the formula for that:
=TEXT(ROUND(J46/C46,1),"0.0")&" : 1"
I am thinking that the same solution will work on the both formulas.
Sorry for sounding really dumb but not used the "IF" formula very much!
Any help appreciated
Thanks
|