Trying to convert feet and inches to decimal

wberg82

New Member
Joined
Feb 19, 2016
Messages
38
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
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Obied70

Board Regular
Joined
Nov 4, 2015
Messages
167
what do you mean by NOT WORK? Have you tried using IFERROR instead of IF?
 

wberg82

New Member
Joined
Feb 19, 2016
Messages
38
Asala42 -

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

Watch MrExcel Video

Forum statistics

Threads
1,123,271
Messages
5,600,651
Members
414,399
Latest member
Ninjee

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?

Disable AdBlock

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
Top