excel 2014

  1. T

    Move to next cell with Vlookup and Left function

    This is what I'm trying to do. I want to look up THE FIRST 5 characters of a cell against another sheet which has multiple names with thIS first five characters. What I would like to do is once it finds the first match that I can THEN move to get the second match etc. Below is an example of what...
  2. T

    Trying to convert 2 cells from inches to inches and feet. Then need to multiply them together to get a square footage. All in one cell

    Hello All, Here's the issue i'm having. In cell A3 i have 66". I take the formula =INT(A3/12) & " ft. " & MOD(A3,12) & " in." which gives me 5ft. 6in. - PERFECT Now I get lost. Lets say C3 is 66" as well. i need that to convert to (5ft. 6in.), then I need to multiply A3 and C3 together to get...
  3. A

    VBA Code for Multiplying/Adding two Excel Cells

    Hello, What VBA Code should I use to multiply two excel cells separated by commas and return the dot product? Ex. Cell A1 = 1,0.512,2 Cell B1 = 25,3,1 Cell C1 = 1*25+0.512*3+2*1 Also, what VBA code should I use to add the numbers in one cell? Ex. Cell C2 = 25+3+1 Thank you

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
Back
Top