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
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Obied70

Board Regular
Joined
Nov 4, 2015
Messages
177
Office Version
  1. 365
Platform
  1. Windows
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 :)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,990
Messages
5,834,751
Members
430,315
Latest member
bobh63

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