1. already

    calculating taxes

    Hi, I have to calculate taxes on an amount of 283000 euro and for furter use as template 3% on the first 50.000 euro 9% till 250.000 euro 27% above 250.000 euro What is the best formula to use for this. Thanks in advance Kind reagrds Al
  2. W

    Issues when sharing a workbook

    Hi. I have created a workbook with multiple sheets for each of my colleagues. There are vlookup formulas and sum formulas that pool data onto a singleaster spreadsheet that gives me an overview of how much work we have gotten through. My issue is that when the book is unshared and on my...
  3. E

    Calculating Time

    I have a spreadsheet detailing employee time swipes through a card reader. Unfortunately, all of the time data is in a single column. What is the easiest way to calculate hours worked per day? I'm looking at all data for all employees from January 2011 through February 2011, so it's a large set...
  4. T

    Something about this code is making Excel Freeze

    Hey all! I think it might have something to do with the subsequent calculating, but this code seems to be the culprit when it comes to making my Excel seemingly freeze: Dim rng As Range With ActiveSheet.Range("E12:E600") Set rng = .Find(What:="Total", LookAt:=xlWhole, LookIn:=xlValues)...
  5. N

    Calculating mulitple workbooks

    I am new to the forum and not a pro with Excel but I am some what familiar with it's capability. I use excel to calculate cost and profit with my business and now would like to use to use Excel to monitor my inventory. Here's my situation on my computer: Folder: Order2010/AprilOrder.xls Folder...
  6. N

    Caculating selected cells

    Hello everyone! I have a huge spreadsheet, about 450,000 rows of data with multiple formulas and pivot tables, so anytime I want to calculate, it takes a very long time. I just want to recalculate some of the formulas, so is it possible to select the specific cells with the required formulas...
  7. R

    MOD 10 calculting

    Dear all, I have that formula on excell to calculate the MOD 10 value for a DIGIT CHECK. BELOW THE FORMULA. <o:p></o:p> =10-MOD(SUMPRODUCT(--MID(A1,{1,3,5,7,9,11,13,15,17},1))+<o:p></o:p> SUMPRODUCT(--MID(A1,{2,4,6,8,10,12,14,16,18},1)*3),10) It works for a number but it is not working...
  8. Solola

    Excel not calculating

    I have a fairly large excel workbook (9420 KB), and it has just recently decided to no longer calculate. When I update numbers that I know will affect multiple worksheets, nothing happens. Yes, I have automatic calculation on. Even when I hit F9, nothing happens. The only way to get the...

Some videos you may like

This Week's Hot Topics