## Discussions Showcase Albums Media Media Comments Tags

1-12 of 12 Results
1. ### Excel 2010: link two cells with formula to count days and hours

I'm updating a spreadsheet that currently manually logs employee vacation time. It's formatted in two cells like this: 20D | 0.00H (meaning 20 days, 0 hours; the "D" and "H" are added automatically in the formatting) As vacation days are reduced, let's say by 4.75 hours one week, then I...
2. ### Solved Help with IF then Roundown formula

Hi, I have two cells, cell #1 contains my calculated value, and cell #2 has a formula to round down cell #1 to the nearest 99. This works well when cell #1 and cell #2 are not the same, but when they are the same, it still rounds down but I'd like cell #2 to stay the same as cell #1, and not...
3. ### Solved SUMIFS help

I need help coming up with an excel formula I'm not sure if I need a SUMIF, SUMIFS or some other formula. Each patient is assigned codes (B2:E2) and each code has a value (A5:B11). I need to add up the total value for each patient. The example below only gives a total of one code (in C2). How...
4. ### Excel for registration

Hello! I need help in speeding up the process for registration during an event. Basically I have several spreadsheets with list of guests that will be attending a event. (Will upload a template spreadsheet) IDENTIFICATION NO. NAME ATTENDING REGISTERED? TIMESTAMP...
5. ### Solved Help with formula

Good afternoon, It's been some time since I've posted on here. I have a spreadsheet which has a number of sheets and one that collates stats from a huge list of data. I use a formula, which looks through the data and returns a number based on number of visits in a month: =SUMPRODUCT(('All...
6. ### Solved Multiple Formula's In One Cell | Excel

I am currently using the formula =SUM(B3*140%) to get a mark-up of 40% when entering a price, but I would like to round this up to the nearest £0.50. Please see spreadsheet attached. Is there anyway to add this formula along with the current one?
7. ### Solved Need help with Excel formula

I attached a picture of the spreadsheet/current formula. I would like to add another formula into cell K101 so that when a value is entered into M101, K101 goes to 0.
8. ### Excel Mulitple Formula Help

I am trying to add several cells together, and if the result returns a positive number add that number to another cell. H8+H12 go into H21 But if H20 is positive I wanted to add that into the total of H21 as well. I think it will two formulas, but I am not sure how to do it...
9. ### Excel drop-down selects alternate data.

Please see attached. I am trying to make a costing sheet that uses data from another sheet. Depending on the classification the user chooses on the first sheet defines what data is pulled from the second sheet. The pricing is banded by units and then additional units on top of the top band are...