forumula help

  1. C

    Suming numbers until a positive number is reached

    Hello, I need a formula to reach the output below. I need to have the cells sum the numbers before it that are negative and have it stop once it reaches a positive number. Also, if the number is negative I need it to end up as 0. Thanks in advance for any contribution you make to helping me get...
  2. B

    MS Excel 2013 Macro Runtime Error 1004 on Formula FillDown

    I am failing to find how to make this new macro run smoothly in other worksheets. The code fails when I copy down the clean formula to the bottom of the column (underlined and in Italic below). I have gone through the forum and sorry, but I am not seeing a solution to work. Thanks for any clues...
  3. G

    Combine 3 forumlas

    Does anyone know if i can combine these 3 into 1? Having trouble figuring it out. =LOWER(CONCATENATE("/",C2,".html")) =SUBSTITUTE(c2," ","- ")
  4. C

    Need Help modifying a Formula

    Hello all , I have a rather complex forumula that was from a pre-existing sheet. I did not create the sheet. But it works very well. Basically this formula counts all the Letters in a row I d like to modify it so it sums any numbers, and remove the weekday restriction (We now have people on...
  5. K

    Whats wrong with my code?

    Hi, I'm compiling a master spreadsheet that pulls values from about 75 other sheets. I made a mistake and dont want to fix it cell by cell, so ive been trying to learn how to write a macro (trying and failing). Here's what is in the cells of the range concerned...
  6. M

    Vertical Lookup Formulas

    I'm trying to create a formula (I'm thinking I should be using a VLOOKUP formula) in my spreadsheet on cell K68 to display a different daily percentage that would exist in cell range F57:F80. For example, On 12/17, I want cell K68 to display 1% On 12/18, I want cell K68 to display 2% On 12/19...
  7. N

    Schedule Worksheet, Issue with displaying Hours worked as general number

    Hello, I am trying to accomplish the following in a single excel sheet. -Display a one week working schedule -Calculate Hours worked for shift and subtract 30min lunch for shifts over 5.5 hours -Calculate each individual Employees daily hours as a general decimal number (example 7.5)...
  8. B

    Rookie Needs Help

    To say that I am NOT an excel guru would be an understatement. I have to create a formula that will pull data from lines above and input it on the same row as the data that I want to review. The lines above the data are always the same but the quantity lines can be anywhere from 1 to 100 long...

Watch MrExcel Video

This Week's Hot Topics

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