calculation

Can someone please give me a detailed example of what this means? Do not use forward referencing and backward referencing To increase clarity and avoid errors, design your formulas so that they do not refer forward (to the right or below) to other formulas or cells. Forward referencing usually...

Hello, I need some help with creating a formula. Basically, I am counting up all the letters in a row (P, F, U, B, S) and then I want to minus from the calculation the count of (L) in the row … however, if L = or > zero, I want the cell to be 0 . my current formula...

Hey Dear community, I use VBA to calculate very big files, with my pc ( 6gb ram ) it takes 35 - 40 minutes for calculation. I wanna know what if i make same calculation with server? ( 125gbram etc ) will there be very big difference in calculation time? or is there calculation time limit...

I have a Excel spreadsheet for users to input the data and it came with all the formula for auto calculation etc. The file size is getting big. I was thinking to learn and switch to MS Access and would like know can Access able to perform the auto calculation as what Excel does?

Hello, Having trouble with a user form I am building. What I am trying to accomplish is a calculation to auto show in textbox1 the number of days between today and what is entered in datepicker1 - even when datepicker 1 is at default of today. Thank you,

I need to prevent my sheet from constantly recalculating the RAND() function on the sheet any time I do something. I tried to change the Calculation Options to manual, but that was for Excel and not my specific sheet. My Sheet, Cases (2), has multiple RAND() functions but once I generate the...

Hey Dear community, I am using VBA+ formulas to analyz sales data ( about 1000,000rows ) it takes 7-8 minutes for calculation, i wanna know if there any other way to make it faster? because i need to calculate this report daily. I use following VBA for 80-90 different ranges on that report...

I am an intermediate/advanced user of Excel but have never tried to learn VBA. All the work I do is very calculation and chart heavy, working with time-series and statistics etc. A typical worksheet might include several columns of price data, from which there are several other columns of...

HI Can you set excel up so that I can do manual calculations on one workbook only? I know how to do it on formulas tab but it sets all my excel workbooks for manual calculation and need one specific book only to have it. Any Ideas?

Hi All, I have formula with calculating order and after round in up to nearest 100. I have issue with one additional argument - if result is bigger then 0 but smaller then 500 round up to 500. As my minimum order is 500 after this its just 500+100 ect... any suggestions ? :confused...

Hello, I have a Fact table like this: <tbody> Product Customer Region Date Sales </tbody> In the middle of a calculation, I would like to put that table in a variable with the following filter: <tbody> Based on...

Hi guys, can someone tell me how to I need to change this function so I can enter a Time wenn the Cell has a certain value. =if("A1"="Break";16,5;B1/C1) it is german so that is why the";" is writing not like the english version "," But what I like to achieve is that in the cell gets writen...

Hi I am using the if function in the calculation of tax . am looking if it is possible to use vlookup index match to calculate the tax amount

Hi All, I created a calculator with data validation and then created a formula to calculate qty of t-shirts by color by size using SUMIFS, but when I change the data in the calculator, the data leaves the previous cells calculation, For example, if I have 5 green t's in small, the result is in...

I'm struggling to work out a formula to round off time to the nearest 15 minutes. Basically the numbers are timesheet entries and they need to be rounded in the following format: <tbody> Current Format Desired Output 02:19:04 2.5 01:37:00 1.5 03:55:23 4 </tbody> I've been able to...

I built a fairly large and complicated financial model for valuation purpose, I’m now concerned with calculation speed. A couple of questions: Does table slows down calculation a lot? My data is kept in tables so that other formula referring to the data will auto update when adding deleting...

Hello MrExcel gurus, The title of this post has the jist of my question, but here's a bit of background: I'm trying to optimize a very bulky financial model. I've got calculation time down to a couple seconds or so, but I'd like to isolate the specific cells whose calculations are still...

I am trying to create a formula that will create a result for a cell if a range of three cells has a value: IN K6-------> IF D6 contains value multiply G6 by 15 IF E6 contains value multiply G6 by 15 IF F6 contains value multiply G6 by 10 Each row (6-xxxx) will have a value in ONLY one cell...

HI, I am sure this is a very quick question/answer, In one cell(D38) I have a SUMIFS formula, the answer it is returning is 0.415. This number is actually a calculation of months in decimals. In the next cell (E38) I have a vlookup to return this figure in months. Cell D38 is rounded to 2...

Is there a way to have a cell value equal the "2019" and have this value used for formula calculation purposes but have the cell display "2020", even though it's value would be "2019" Thank you