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 you
HFM 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 combination
Help 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!!
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?Adding 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.
