Trying to convert feet and inches to decimal

[wberg82]

Ok, so I cannot figure out how to get excel to ignore BLANK cells to complete my conversion. If the cells the formula is pulling the information from have a value then my formula works. If the cell that the formula is pulling the information from does NOT have a value, my formula does NOT work. Below is what I am trying to do.....

Cell J13 is my numerator
Cell L13 is my denominator
Cell I13 is my "whole" inches
Cell G13 is my "feet"

So I am trying to write a formula where is converts this into a decimal. If I was typing this on my calculator it would be (((J13/L13)+I13)/12)+G13. However sometimes I do NOT have fractions on an inch so these cells would be blank. This is where I am having a problem. Any help would be much appreciated.

Below is my current formula....

=(IF(J13=" "," ",J13)/(IF(L13=" "," ",L13))+I13)/12+G13

 

[Obied70]

what do you mean by NOT WORK? Have you tried using IFERROR instead of IF?

 

[Asala42]

Try:

=((IFERROR((J13/L13),0)+I13)/12)+G13

 

[wberg82]

Asala42 -

Tried this and it worked! Very simple formula. Thanks for the help