Forum Widgets
Latest Discussions
IFS or anyother function
Dear Experts, I have a data like below:- So, Column "B" - sfn can go from 0 ~ 1023, and Column-"C", can go from 0~19, Column "G" has 3 values(rnti's) - Now, we have only 2 situations like below in Column"E", where I need the formula:- Either all these 3 rnti's can be Multiplexed in the same sfn.slot So, in below snip all 3 rnti's are FDMed in same sfn.slot - 394.6 and should be continuous, so Column "E" should have fdm-3 But in below instance, in 395.2 we have only 2 rnti's multiplexed(so fdm-2 should be populated) Attached is the spreadsheet. Thanks in Advance, Br, Anupam38Views0likes3CommentsAdding COUNTIF formula to cell by VBA code
Morning all, need some assistance. Attempting to insert a new formula by VBA with an already working Macro. All the other references unhighlighted below work perfectly, but I am missing something with the syntax around a countif function. The countif currently works on the excel sheet itself, however adding it into the VBA is generating the typical "Compile error: expected: end of statement" error indicating a syntax problem. Any advice?JoeCavasinJan 18, 2025Brass Contributor8Views0likes1CommentFormula Error-#DIV/0!
We are using this formula in Q7 -=IF(MAX(ABS(1-(K7/G7)),ABS(1-(G7/K7)))<0.1,"PASS","FAIL"), it works great, except: when K7 & G7 don't have amounts in them, we get the #DIV/0! error. Is there a formula we can add to the above to leave Q7 blank until K&G 7 are filled in?SolvedapinterJan 18, 2025Copper Contributor584Views0likes5CommentsTRANSLATE() function not available in Excel
I would like to evaluate the new TRANSLATE function, but it is not available in my Excel. My Specs: Windows 11 ARM 64bit Excel version 2409 Insider Beta Channel OS and MS365 both fully updated.SolveddatamanjpJan 18, 2025Copper Contributor8.9KViews0likes9Commentsunderline in cells not present after leaving cell
I am trying to insert a header on a page and in the left header cell, insert text and underline. The text and underline can be inserted and is displayed when the cell is highlighted, but when I leave the cell the text remains, but the underline disappears. Printing the document the text is printed, but the underline is not. The underline is intended to be a "marked" space to write in text on the printed document. I've tried different methods to apply the underline, but the same issue occurs. Any suggestions?jwilsonJan 18, 2025Copper Contributor18Views0likes2Comments'apostrophes
new problem only on this computer. using excel now my spreadsheets are useless as they now have an apostrophe added to the beginning of each cell eg 'Alec '8482 '1=3 is there a button I need to unclick or something??? it has to be on this computer as I sent an unaffected workbook from another computer but it read the same once opened on this computer. hence this computer must have something activated to put ' on every cell. does anyone have any solutions to this please?Fox1223Jan 18, 2025Copper Contributor25Views0likes1CommentKeep a number as "General"?
How do we keep a column of numbers as type General? For example, I have column L. I highlight column L. I set type of the entire column L to General. I go into several cells in column L and confirm that they are type General as I had set them to be. So I enter a general number into my cell that I set as a general cell. Excel decides that, no, what I really really want is for that cell to be set to Accounting which means that the cell displays ###### unless I widen it, at which point it becomes a dollar figure. But I'm not dealing with dollars. I'm dealing with general. Which is what I had set the column to be. So I have to go back EVERY TIME I enter data into a cell and switch it back to General which is what I already set it to in the first place. This would make some sense if I had entered 1/17/2025 and it decided to change what I told it (General) to a date, even though I had already told it that I want it to be general and therefore display the '1/17/2025' that I had entered. But if I enter '10230' into a cell that I had specified needed to be General, Excel should not decide that I wanted it to be $10,230.00. I did not. How do we prevent Excel from overriding our settings?GalenMcMahonJan 18, 2025Copper Contributor31Views0likes1Comment
Resources
Tags
- Excel42,017 Topics
- Formulas and Functions24,355 Topics
- Macros and VBA6,329 Topics
- office 3655,900 Topics
- Excel on Mac2,606 Topics
- BI & Data Analysis2,315 Topics
- Excel for web1,868 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,602 Topics