Please help!

So I need to figure out a formula that will work for my spread sheet. It must take the text in H3 to figure out if it is "Yes", "No", or "Heat Transfer, (Print Only)". Then it need to take G3 and add .5 to it. Then I need all to convert into feet and inches [=INT(SUM((**Formula to go here**)))&"' "&TEXT(12*(SUM((**Formula to go here**))-INT(SUM((**Formula to go here**)))),"#")&CHAR(34)]. See the screen shot for reference. Screen Shot 2016-05-26 at 5.38.16 PM.png

Originally Posted by FDibbins

Hi kc7, welcome to the forum

Sorry to do this on your very 1st post ...

1. Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

2. Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Thank you! I ended up figuring out the formulas I just had to voice it to someone and then it all started clicking together in the ole noggin!