calculate based on value

  1. A

    If-then Calculation Across Rows/Columns Based On Other Columns.

    Greetings guru's, total excel Newbie here. So new, I don't even know how to properly term what I'm trying to do in order to search it. I'm confident there's some excel calculation guru's here who can explain it to me like I'm 5 months old (in excel years), hopefully I can explain the...
  2. C

    Formula to return a code per row based on multiple criteria and steps-EXPERT needed

    Good day Excel forum, I need the help of an expert to solve a puzzling and challenging problem. I will try to explain in the shortest way possible, but need to be thorough to explain in clarity. In the table below, I have need of a formula in the "Code" column to do some very specific...
  3. A

    Dynamic Calculations with UserForm Input

    Hi All !! I am having trouble getting a calculation out of my code. I do not know why it is not working the way I wanted to. I have a userform which opens up with checkboxes for two machines that have the same name (Kern 1 and 2) on those machines you could have 1 operator, 2 operators, and it...
  4. A

    Calculating between Current and Previous Row based on Variables on Different Worksheets

    Hi All !!! I am working on a Module that is giving me a headache. I am trying to calculate what I call "changeover time" based on 9 variables contained in a matrix on Sheet("Daily Schedule"). If any of these variables change from the previous selection to the current selection there are times...
  5. A

    Sorting a List based on values from another Sheet

    Hi !!! I started a while ago with a big project and not knowing a lot about VBA, I am still learning and looking up new ways to do things. I am currently trying to sort a list based on 9 different variables (1 of the variables is on sheet "Daily Schedule" and the other 8 are on "CO Times"). I...
  6. J

    Make value negative based on symbol in row

    Hi there, I have two columns In the one column is a symbol and in the other an amount if the symbol in D = P then the amount in Column E should be negative. I then have a total box that will add and subtract the value's together. How do I insert a line automatically when I want to make a new...

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