calculating

Hi, I am new to this forum and would really appreciate some help with a spreadsheet I am working on, I have copied the two sheets onto a new workbook and uploaded it to here: Problem.xlsm All the info on 'Sales Demand 2' gets pasted into that sheet automatically each week, Please Refer To...

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

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...

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...

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)...

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...

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...

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...

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...