Forum Widgets
Latest Discussions
Excel IF/IFS formula not calculating scenario "B"
Hi, Hopefully an easy solution that's staring me in the face, but I've been trying to fix this for an hour and I'm getting nowhere. Any pointers appreciated. I've been working on a new calculator workbook and in the final stages I'm having issues with the IFS function. The workbook will calculate a different total for each cell depending on the scenario chosen. I have two variable outcomes, due to a known value only being possible for either S15 or S21 (and the unknown value being resultant/residual). Cell S15 = A residual or fixed number dependant on toggle selection Cell S21 = A residual or fixed number dependant on toggle selection I have two "control" cells that determine the fixed value of S15/S21 as applicable. The control for S15 is Z17 and the control for S21 is Z18. The other cells referenced in the formula below are all subtotals of either revenue or cost. I have managed to get S15 to calculate correctly using only the following "IF" formula as such: =IF(S9="YES",SUM(N52+N57)-(S16+S17+S18+S19+S20+S22+S43+S49+T64),Z17) This completes the residual calculation if the scenario is "YES". It defers to cell Z17 if "NO" is selected. Perfect. On the second part of the equation I cannot get it to calculate correctly. So far I have tried: =IF(S9="YES",(N52+N57)*Z18,SUM(N52+N57)-(S15+S16+S17+S18+S19+S20+S22+S43+S49+T64)) This returns the correct calculation for "YES" no matter the list selection. =IFS(S9="YES",(N52+N57)*Z18,S9="NO",SUM(N52+N57)-(S15+S16+S17+S18+S19+S20+S22+S43+S49+T64)) This returns the correct calculation for "YES", but returns a blank for "NO".
Suddenly excel slows down or crashes with history files
Good morning, I am a italian A1 volleyball data analyst (female) and I use Excel to create my match sheets. Opening one of my files in the last few days the file blocks the application or slows it down so much that it is not possible to use them. I have w11 and Office 365 personal updated to the latest versions. I have already uninstalled and reinstalled Office 365 but the problem persists. Opening the file from "Libre Office" there are absolutely no problems and I have been using these files for at least 3 years in Excel.
Invalid procedure call or argument (VBA Error 5 Excel) in Build 19011.20000
Version 2507 (Build 19011.20000) gives the following VBA error in Excel: "Invalid procedure call or argument (Error 5)" It stops at the following line in VBA: === qv_wiel = WorksheetFunction.Min(3 * wiellast / (2 * Pi * Sqr(Sqr((x_wiel - x0) ^ 2 + (y_wiel - y0) ^ 2) ^ 2 + H_eq ^ 2) ^ 2) * Cos(WorksheetFunction.Radians(WorksheetFunction.Degrees(Atn(Sqr((x_wiel - x0) ^ 2 + (y_wiel - y0) ^ 2) / H_eq)))) ^ 3, wiellast * 4 * (1 / 4 - 1 / (2 * Pi) * (WorksheetFunction.Asin(2 * H_eq * Sqr((4 * H_eq ^ 2 + L_strook ^ 2 + B_strook ^ 2) / ((4 * H_eq ^ 2 + L_strook ^ 2) * (4 * H_eq ^ 2 + B_strook ^ 2)))) - 2 * H_eq * L_strook * B_strook / Sqr(4 * H_eq ^ 2 + L_strook ^ 2 + B_strook ^ 2) * (1 / (4 * H_eq ^ 2 + L_strook ^ 2) + 1 / (4 * H_eq ^ 2 + B_strook ^ 2)))) / (B_strook * L_strook)) === This issue didn't exist in Version 2506 (May 2025) and lower.Create table using LET based on column values
Hi all Hope you can help. I am trying to create an output table based on another tables column data. Example: Original Data Table: Task Target Group 1 Group 2 Group 3 Group 4 Task 1 10 5 10 Task 2 20 10 Task 3 10 5 15 16 Task 4 50 90 10 20 19 Output Table Desired: Tasks Team Result Task 1 Group 1 5 Task 1 Group 3 10 Task 2 Group 2 10 Task 3 Group 1 5 Task 3 Group 2 15 Task 3 Group 3 16 Task 4 Group 1 90 Task 4 Group 2 10 Task 4 Group 3 20 Task 4 Group 4 19 Any advice where to start please? ThanksUsing Filter to return rows with certain conditions
I want to return the rows where "maturity date" column is higher than "Asofdate" or is lower than "IssueDate". I tried this formula =FILTER(INDIRECT(C12&"[#All]"),(INDIRECT(C12&"[MaturityDate]")<INDIRECT(C12&"[IssueDate]"))+(INDIRECT(C12&"[MaturityDate]")<INDIRECT(C12&"[AsOfDate]"))) but it gives me #Value error. What would be the correct formula? C12 definitely has the correct table name so can't pin point
Excel FILTER function not working with some formulas
Hey all, Very weird issue: The FILTER function doesn't return anything when the target cell contains certain (but not all) formulas. For example, it would work if I manually type 0.1 but it will NOT work if I have a =11.9-11.8 formula. It DOES work however on =0.05+0.05 or = 2.9-2.8. I tried formatting the cells every possible way - general, number, indentation, etc and no go. Attaching some screenshots. Could you help me out?Issue with INDIRECT formula
Hi Guys i am having an issue with running a Indirect formula to take intersect a column and a row of a "skill vs will" matrix to give an intersecting answer. I have created from a selection in the name manager section in formulas, have set drop down lists for each column and used the formula =INDIRECT(I18) INDIRECT(J18) It is only affecting 2 rows from the matrix but other than that it works Anyone got any tips?
