Forum Widgets
Latest Discussions
Use IF formula with 3 conditions based off of 2 cells
Good day all. I am trying to write an IF function that looks into Cell A2, which has Dates, and returns "PD" if is less than Today() or "TC" if it is greater than Today() in Col C. However if in Cell B2 there is a Paid On Date I would like for it to return "P" in Col C. I have this incomplete formula in Col C: =IF(A2<TODAY(),"PD",IF(A2>TODAY(),"TC")). I don't know how to add the third condition. May someone help with this? I have enclosed a reference image. Column D is an example of how I would like it to be returned please. thank youitsMontyJun 24, 2025Copper Contributor51Views0likes3CommentsSpreadsheet refuses to change Date Serial number to mm/dd/yy format
I have tried changing the column formatting, and using text to column copying and DATEVALUE formulae, and copying the columns to a blank spreadsheet & back. Nothing. What's wrong?ronjohnson2redcrossJun 24, 2025Copper Contributor29Views0likes2CommentsHFM formula does not work in Automatic Calculation options mode
We are encountering an issue when saving Excel workbooks that contain HFM (Hyperion Financial Management) formulas using Aspose.Cells. The behavior varies depending on the calculation mode configured within the workbook: Manual Calculation Mode: The HFM formulas are preserved correctly upon saving. The data remains visible, although in some cases, it appears with strikethrough formatting. Automatic Calculation Mode: The formulas are either lost or fail to retain their expected values after saving, resulting in missing or incorrect data. We have attached two sample workbooks for your reference: One opened in Excel 2016, where the data displays correctly. The same file opened in Office 365, where the HFM data is not displayed as expected. Here is an example of one of the HFM formulas used in the file: This formula is used to retrieve data from HFM via Smart View. In Manual mode, the formula persists and displays data (albeit sometimes with strikethrough). However, in Automatic mode, the formula either disappears or does not function as intended. We would appreciate any guidance or insights you can provide on how to preserve these formulas correctly across different calculation modes and Office versions when using Aspose.Cells. Both excels are in this shared drive, https://drive.google.com/drive/folders/1WgTKSL-W4tuBT1U4nqJW18xUHzJ4K73o?usp=sharing We also observed Automatic Calculation options work or not work in this combinationmeghnabilimoria-insightsoftwareJun 24, 2025Occasional Reader38Views0likes1CommentHelp with Excel report creation for review results from multiple worksheets...
Windows 11 MS Office 365 Cloud Accessed from Citrix desktop I've been working on this project for a while and have a tracking spreadsheet for several review categories, each on its own worksheet tab. I have a results page that gives me the data I need. The table on the RESULTS tab contains the results for the reviews and marks them as either having 'Not Met', 'Met' or 'Exceeded' the goal for each category. The final piece of the project is giving us problems. I received a great deal of help with it from @HansVodelaar here on the forum and he got very close to solving it. I've included the spreadsheet with the final attempted 'Result' tab. Here is what I'm trying to do now... Automatically generate a simple report Based on the generated date on 'RESULTS' for the selected Rep That lists all records, Labeled by review category (see review tabs), From the designated start date to designated end date, Only for the categories with scores designating them as either 'Not Met' or 'Exceeding' the goal. So far, the 'Report' tab works to list the records. However, there are a couple of problems with it. I can't seem to successfully copy the formula to the master workbook, which holds the same structure, but is not redacted. The returned data, as is, only separates the categories by a blank line, but does not identify to which review tabs (categories) the results belong. Any help offered is greatly appreciated. Hans suggested that the solution may require use of Power Query. So, if anyone has an idea of how I can accomplish this report without having to go into each tab to filter, sort, format and print, it would be totally awesome!!Marcus_BoothJun 23, 2025Copper Contributor109Views0likes16CommentsHelp with Excel 'Format copy' does not include 'new line (Alt Enter) within a cell.
Hello, Note that Excel 'format copy' does not copy over the 'new line (Alt Enter)' within a cell. Is there another way to copy format of a cell that includes the 'new line' formatting?pspisarJun 23, 2025Occasional Reader22Views0likes1CommentExcel 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?SolvedBreakingBadlyJun 23, 2025Occasional Reader36Views0likes1CommentAdding an end time to existing row using VBA
I have the VBA set up to enter the date and time for when they start an order, but I need help for when they finish an order. When they finish the order and click the "Finish" button, I need the VBA to look for the original transfer number in the Data tab then return the end date and time (yellow). I realized that with the VAB I have now, it is starting a new line and entering the end time. Attaching the file. Thank you in advance.CatherineMaddenJun 23, 2025Copper Contributor126Views0likes3CommentsExcel page break not working
I've created page breaks in Excel spreadsheets many times, but all of a sudden the feature isn't working in Excel 365. Any suggestions? I go to Page Break Preview, where everything is on the one page. I then position the cursor about halfway down the sheet in Column A, go the Page Layout and click on Insert Page Break. Absolutely nothing happens. Even if I select the Remove Page Breaks option beforehand it still doesn't work. Is there a bug in Excel 365? How can I overcome it?SolvedSpydahJun 23, 2025Copper Contributor123KViews1like21Comments
Resources
Tags
- excel42,846 Topics
- Formulas and Functions24,858 Topics
- Macros and VBA6,442 Topics
- office 3656,087 Topics
- Excel on Mac2,666 Topics
- BI & Data Analysis2,399 Topics
- Excel for web1,938 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,655 Topics