formulas and functions

25379 Topics

Excel worksheet protected but can't use text to column function
HI I have a worksheet that several people use that I need to protect. There are formulas and a pivot table. I have been able to lock what I need and am able to refresh the pivot table but I can not use the "text to column" function in the raw data as its greyed out. The area in question are not locked cells but the function is still unavailable. We need to be able to use the text to column function but I also need the sheet locked to protect the formulas.
YoBro
Jun 24, 2026 Place Excel
6Views
0likes
0Comments
Frozen App
I am a novice in Excel and my spreadsheet and all Excel functions are frozen by the appearance of a pop-up that includes a GoTo field first and a Reference field below that . I am guessing that this box is part of creation of some formula(?) but I have no idea how to clear it. It will not cancel, delete, or "x out"; I rebooted the entire computer hoping to reset but it didn't work and it has locked up everything. Is there a way to cancel this action and save my open spreadsheet? JT26
JT26
Jun 22, 2026 Place Excel
5Views
0likes
0Comments
Template for capacity planning
I'm working on creating a capacity planning spreadsheet and thought I'd ask to see if anyone knows where I can find a template with pre-built macros. Needing to create a capacity need plan for a call center.
ffswpf
Jun 22, 2026 Place Excel
48KViews
0likes
2Comments
Rounding Issues
I am trying to create a "change maker" spreadsheet. We have a need to determine monetary denominations for several clients for refunds... A B C D E F G H I J K L Random Money 100 50 10 5 1 0.25 0.10 0.05 0.01 775.1047 775.10 7 1 2 1 0 0 1 0 0 $775.10 949.3219 949.32 9 0 4 1 4 1 0 1 2 $949.32 947.3099 947.31 9 0 4 1 2 1 0 1 0 $947.30 1231.75 1231.75 12 0 3 0 1 3 0 0 0 $1,231.75 1180.4836 1180.48 11 1 3 0 0 1 2 0 2 $1,180.47 1486.3901 1486.39 14 1 3 1 1 1 1 0 4 $1,486.39 59.166 59.17 0 1 0 1 4 0 1 1 2 $59.17 1450.5418 1450.54 14 1 0 0 0 2 0 0 3 $1,450.53 1042.6726 1042.67 10 0 4 0 2 2 1 1 2 $1,042.67 88.9004 88.90 0 1 3 1 3 3 1 1 0 $88.90 457.3006 457.30 4 1 0 1 2 1 0 1 0 $457.30 The formulas: A: ROUND(RAND()*(1500-30)+30,4) - random number generator to create random money amounts between $30 & $1500 B: ROUND(A3,2) - round A to 2 decimal places for money C2: INT(B3/$C$2) - Calculate $100's (simple) C3: =INT(($B3-(SUMPRODUCT(ROUND($C$2:C$2,2),ROUND($C3:C$3,2))))/D$2) - Calculate each other denomination - requires keeping track of current balance.. D3:K3 - Similar to C3 adjusting for col/row... D3-K3 are same as D2 adjusted for col/row... L3: ($C$2*C3)+($D$2*D3)+($E$2*E3)+($F$2*F3)+($G$2*G3)+($H$2*H3)+($I$2*I3)+($J$2*J3)+($K$2*K3) - Error Checking... The problem is in the Pennies column. Sometimes it is off by $0.01 as in rows 4, 6, & 9 A secondary problem that I am having is copying formulas with $... Sometimes when I copy a formula down that has ROUND($C3:H$3,2) for example, the H$3 turns into H3 and the $ is removed. In other cases it is added where it didn't exist. Is this normal behavior? I thought the $ was there to fix the row/col reference? MK
Solved
JuJuBee
Jun 22, 2026 Place Excel
41Views
0likes
2Comments
Formula Excel Help
Hi, I'd like to create a formula which looks at column F and if it contains words, "Jay", "Em" then to go to column B AND C and if they both state 'Complete' or 'NA' then to return words in column D with 'Case Closed' If column F does not contain 'Jay' or 'Em' then return a blank If one of the two Column B and C contain any other words then column D should return words 'Case Open' Hope that all makes sense. Is this possible? At the moment I have a formula which only looks at column B and C, this is the forumla with the actual column table headers: =IF(AND([@[Servicing Status]]="Complete", [@[Complaint Status]]="Complete"), "Case closed", "Case Open")
Solved
Jna3276
Jun 20, 2026 Place Excel
9.6KViews
0likes
24Comments
Pivot Table
Hi everyone, I have an issue with the pivot table. There are filters from slicers and row labels in the table; when I double-click on any category from the table to see the filtered data, Excel fetches all data, not just what I filter on. Like below, I filtered from the slicer, and from the row labels, (Bills) should be between 100,000 and 200,000. I would like to see the (Bills) for (Central) in the (Start), but it gives me 632,478 and bills less than 100,000 and 200,000, not the 3 clients. Even if I tried from (In Progress), it's the same; it brings all data. The issue is only with the Bills column, but other filters come up correctly
Ahmed9
Jun 20, 2026 Place Excel
75Views
0likes
1Comment
Excel add same formula easy way
Hello, I have numbers in C1 till Z1 cells. I would like to multiply these cells value with A1 value. Example: +A1*C1, +A1*B1......+A1*Z1 I know I could write one by one. But is there a simple way to add all cells to this formula? So if I change A1 cell value all the values have to change. C1-Z1 is not fixed. It have to change when A1 changing.
lanszelot
Jun 19, 2026 Place Excel
1KViews
0likes
6Comments
Excel image not showing up on Windows users
I use Excel on Mac, and I've prepared a quotation list with all of the product images inserted into cells. When I send the Excel document to another Mac user, they are able to see the images. However, when I send it to a Microsoft user, they don't see any images in the document. I've attempted to upload it to Google Drive, but I encountered the error message below: Does anyone know a solution to this?
Feydalgin
Jun 18, 2026 Place Excel
1.1KViews
0likes
2Comments
CountIFS/SumIFS Question
Hello everyone, I'm working with a lot of data, and trying to find a way to add quantities already in the sheets but spread out over 500 or more rows. I'm not able to change how the data is delivered to me, as it's a downloaded file from a 3rd party. Here's a sample of what I'm looking at: A B C D Plain Bagel 7 Plain Bagel Bagel Spreads Cream Cheese 5 Plain Bagel Bagel Spreads Butter 2 Plain Bagel Toasted/Warmed Yes Toasted/Warmed 7 Double Espresso Food Selection Plain Bagel w/ Cream Cheese 4 Hot Chai Latte Food Selection Plain Bagel w/ No Spread 2 Iced Coffee Food Selection Plain Bagel w/ Butter 6 Basically, I'm trying to add the numbers in column "D," but only if these requirements are met: If column A says Plain Bagel, column's B and C have to be empty. If column C has any type of Plain Bagel, then those should also be added. In case it's needed: I'm currently using Excel for the web, but I do have access to the desktop version as well.
Solved
AKing123
Jun 18, 2026 Place Excel
230Views
0likes
12Comments
Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team
Sangeeta Mudnal
Jun 18, 2026 Place Excel
66KViews
30likes
98Comments