Excel returns incorrect answer to simple multiplication.
I'm saving a few favourite math examples, and ran into a problem - the last of the calculations came back with an incorrect answer. I'm using a simple =cell1*cell2 formula. It should end with 21. Please help I'm using android app. All cells formatted as numbers.
Revenue structure
File Structure Reference Column A contains Client Names (e.g., A, B, etc.). Row 2 (starting Column B onward) contains month-end dates from Jan 2026 through Dec 2027. Columns B through the last month column contain monthly revenue values. The final column is the Total column (annual total calculation). 1. Termination Logic If a client terminates in a specific month: Revenue should appear normally up to the month prior to termination. In the termination month, revenue should become zero (or stop, based on effective date assumption). All future months (including months in the following year) must remain zero automatically. The annual Total column must update correctly based only on active months. The model must not require manual zeroing of future months — this should flow automatically once the termination month is specified. 2. Fee Update Logic If a client’s fee changes in a specific month: The revised fee should apply only from that month forward. All prior months must remain unchanged. The increase should not assume a uniform annual escalation. The updated fee must flow correctly into the next year without altering historical data. For example: If the fee increases in July 2026, then: Jan–Jun 2026 remain at old rate. Jul 2026 onward reflects the new rate. 2027 months continue with the revised rate unless changed again. It will be great if the formula works on Google Sheet as well.
Help needed with IF and COUNTIFS Formulas
Is anyone able to advise the following formula: =COUNTIFS($B$5:$B$15,$R$4,$C5:$C15,"<=" & V3,$D5:$D15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$G5:$G15,"<=" & V3,$H5:$H15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$K5:$K15,"<=" & V3,$L5:$L15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$O5:$O15,"<=" & V3,$P5:$P15, ">" & V3) Is there a way to simplify this? Is there a way to make this more accurate? Cells in column G & H, I & J, O & P are using the following format: =IF(C6="","",C6+E6) Cells in U4:CC4 are using the following format: =COUNTIFS($B$5:$B$15,$R$4,$C5:$C15,"<=" & U3,$D5:$D15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$G5:$G15,"<=" & U3,$H5:$H15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$K5:$K15,"<=" & U3,$L5:$L15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$O5:$O15,"<=" & U3,$P5:$P15, ">" & U3) Cells in U5:CC15 are using the following format: =IF(U$4>=$T5,1,"") My issue is is when I put in the three break times, the mid break comes out at a shorter time. My other issue is is that when I put in the times in row 5,6and 11, the data is coming up as a combined data in rows 5, 6 and seven on the page two. Just for reference, "page two" is the same spreadsheet. What I need to happen is that I enter in the shift start time and finish time. This then populates through to Break 1, 2 and 3. The Time entry is the time the break starts. ie: 1 hour after start of shift, 1 hour after coming back from break, etc. The break entry is the duration of the break taken. ie: 30 minutes. Once all the info is put in, the relevant "Time Block" on "Page 2" shows a 1. What is happening at the moment is that when I enter all the time data, the time blocks are not populating correctly in accordance to the entry. Basically, If I have numerous people on shiftI need the time blocks to show where I have shortfalls in shift cover and not having too many people on break at the same time. IE: Link to Live Copy: https://www.dropbox.com/scl/fi/eur1j526htu1j8a4d4290/Staff-Breaks.xlsx?rlkey=r4tm9xts4tonofpa2th2cusfw&st=nueyk0d7&dl=0 Any ideas would be greatly appreciated.
Multiple Inventory entries on the same item
Okay so I'm wondering if there is a way for excel to automatically advance to the next column when entering inventory data so if I need to make another entry on the same item I don't have to advance to the next cell myself. This would be helpful in streamlining inventory and making it foolproof when adding inventory to a specific item (without having to worry about deleting previously entered data). I'm hoping there is a way to do this so I can take a tablet when completing my inventory and avoid the old clipboard and paper.
Moving a column of text data into 3 columns of data?
I have a column of text data cells 1,2,3,4,5,6,7,8,9 and longer. I want to create 3 column of data to graph and manipulate Cell in Columns. 1,2,3 3,4,5 5,6,7 8,9,10 and longer. So i need to create 3 columns of data from 1 column of data. I am using Mac Excel 16 and I can not make this happen. I have tried all sorts of solutions. Help? Thank you,Right click menu not Working in excel on iPad pro
Hi All, I am using Microsoft office on my I pad pro m2. Last few days I am not able to get right click menu in Excel. It’s not working at all. The apple IT guys told me that its from the Microsoft side. Now no one is able to sort this issue. I am on I pad 26.1 update which is the lates version. Please help me on this. Regards.
Consolidating nutrition and price data from multiple sources into one Excel dashboard
I maintain a single Excel workbook that tracks breakfast-menu items calories, macros, allergens, and local prices pulled from several public sources like https://mcd-breakfast-menu.com/. Each source formats its table differently: some list energy in kcal and others in kJ; decimal separators flip between commas and periods; prices appear in four currencies. After each monthly update I hand-copy tables into a Raw sheet and try to normalise them with Power Query and a few LET and LAMBDA functions, but one extra column or unit change breaks my mapping. Has anyone built a durable workflow for problems like this? I am looking for ideas on (1) keeping unit conversions transparent so a non-Excel colleague can audit the maths, (2) alerting me when a source table adds or removes a column so the model does not shift silently, and (3) deciding whether to keep all cleanup in Power Query or move some logic into hidden staging sheets. Any real-world templates or processes would be welcome.
Excel file change date and time
English: I use Excel on my cell phone and recently it stopped updating the file change date. As soon as I make a change to the file it shows the current date and time, which would be the time I last changed the file. But after a few seconds it returns to an old date and time change, how can I solve this? Português: Eu uso o Excel pelo celular e recentemente ele parou de atualizar a data de alteração dos arquivos. Assim que faço a alteração no arquivo ele mostra a data e hora atual, que seria a hora que alterei o arquivo pela última vez. Mas passado alguns segundos ele volta pra uma data e hora de alteração antiga, como posso resolver isso?
