# Trying to convert feet and inches to decimal

#### wberg82

##### New Member
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

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
what do you mean by NOT WORK? Have you tried using IFERROR instead of IF?

Try:
Code:
``=((IFERROR((J13/L13),0)+I13)/12)+G13``

Asala42 -

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

Replies
4
Views
374
Replies
4
Views
529
Replies
6
Views
563
Replies
36
Views
2K
Replies
6
Views
382

1,211,871
Messages
6,104,477
Members
447,911
Latest member
rkramapo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back