Pm formula

File seems to work well. I added an IFERROR function to the formulas to remove the errors when cells are empty.However I am getting another error, when I make all the names the same. Under "Pinch Target" some of them say "No pinch" while others sale "0-4". I can't seem to figure out why.Attachment 881091 10-15-2024, 12:23 PM #5 Re: How to expand formula to other cells. Please attach your w/book showing the problems: cannot read the attachment. 10-15-2024, 12:28 PM #6 Forum Contributor Re: How to expand formula to other cells. 10-15-2024, 02:00 PM #7 Forum Contributor Re: How to expand formula to other cells. Hi Joseph,It appears to work, however all the empty cells have "No Pinch" auto-populated into them. Is there anyway to remove that so they are only displayed when data is entered? 10-15-2024, 02:07 PM #8 Re: How to expand formula to other cells. I think formula should be 10-15-2024, 02:35 PM #9 Forum Contributor Re: How to expand formula to other cells. Awesome, that fixed it. However it is now doing it to the other Target columns. They say "Optional". 10-15-2024, 02:56 PM #10 Re: How to expand formula to other cells. I have no idea what formula you are using but the ones I supplied (post #2) are OK. "Optional" only for 4th Target 10-15-2024, 03:01 PM #11 Forum Contributor Re: How to expand formula to other cells. I think I am just getting confused with the 2 different answers. 10-15-2024, 03:05 PM #12 Forum Contributor Re: How to expand formula to other cells. It works, thank you @JohnTopley! 10-15-2024, 11:03 PM #13 Re: How to expand formula to other cells. Originally Posted by Tricks420 Hi Joseph,It appears to work, however all the empty cells have "No Pinch" auto-populated into them. Is there

To Implement ... One formula of professional mind mapping : input data + output dataOne formula of professional mind mapping : input data + output data ... Launch Projects Exchanging Mind Maps with Evernote | Quality ... Quality Mind Maps Quality Project Management with Mind Maps | One formula of ... One formula of professional mind mapping : input data + output data ... PM Presentations | One formula of professional mind mapping ... PM Planning | One formula of professional mind mapping : input ... Launch Projects Exchanging Mind Maps with EvernoteHow To Create Project Report | ConceptDraw PROJECT Project ... How To Create Project Report | How To Hold Project Collaboration ... Professional & Powerful Mind Mapping Software | One formula of ... Why People Select ConceptDraw MINDMAP | Cubetto Mindmap ... Communication Tool for Remote Project Management | Business ... What can you create with ConceptDraw MINDMAP ? | The Mind Map ... Quality Management Teams | Successful Quality Management ... PM Planning | Collaboration in a Project Team | Program for Making ... Communication Tool for Remote Project Management | How To ... How To Hold Project Collaboration via Skype | One formula of ...

01-18-2005, 02:06 PM #1 LOTUS 123 TO EXCEL 2003 I work for a company that is converting all of their Lotus 123 (Dos VersionRelease 2.2) spreadsheets to Excel.I do not understand this Lotus formula =AND(A9>=$AA$2,A9AC2.The "A" column is full of dates.AA2 has another date January 1, 2005, and AB2 has another date January 31,2005.A9 is a dashed line no date or pertinent information. When I can theformula to A10 which is the first cell with a date the AC2 cell now says trueor false.I want the formula to look at the whole column and determine which dates arein between 01-01-05 and 01-31-05. Can someone help me write this formula.--bb 01-18-2005, 03:06 PM #2 Re: LOTUS 123 TO EXCEL 2003 becky wrote...>I work for a company that is converting all of their Lotus 123 (DosVersion>Release 2.2) spreadsheets to Excel.>>I do not understand this Lotus formula =AND(A9>=$AA$2,A9cell>AC2.....This would be the Excel translation of a 123 formula. It's checkingwhether the value of cell A9 falls between the values of cells AA12 andAB12. It does this by checking if A9 is greater than or equal to AA2*and* then whether A9 is less than or equal to AB2. The original 123formula would have been+A9>=$AA$2#AND#A9>A9 is a dashed line no date or pertinent information. When I can the>formula to A10 which is the first cell with a date the AC2 cell nowsays true>or false.That's what the AND function does in Excel. The 123 formula would havereturned 1 (corresponding to TRUE in Excel) or 0 (corresponding toFALSE in Excel).>I want the formula to look at the whole column and determine whichdates are>in between 01-01-05 and 01-31-05. Can someone help me write thisformula.Excel can do that, but how do you want to results of which cells in colA are between these dates and which aren't displayed? It appears theoriginal 123 workbook displayed them as 1s (between) or 0s (notbetween). 01-18-2005, 05:06 PM #3 Re: LOTUS 123 TO EXCEL 2003 HarlanThank you for the information. That is what I thought it was doing, but notbeing a Lotus user I was not sure. I still need the formula to be

06-30-2021, 06:21 PM #1 Registered User Max If with blank cell condition I am trying to modify a normal Max If formula to return the most recent date in a table given a lookup value. However, in the data table, there may be instances where the cells are blank. If any of them are, I would like to return 0. I would only like to return the most recent date if all cells in the found array have values. See below for example.Adam1975Adam1976Adam1977Joe1978JoeJoe1979From this table, if I use Adam as my lookup value, I would like the output to be 1977. However, if I use Joe as the lookup value, I would like the output to be 0 due to one of the cells being blank for Joe. I have tried to do however, it is just returning the normal return as if I was using a normal Max If formula. Any help on what formula would accomplish this would be appreciated. 06-30-2021, 08:50 PM #2 Re: Max If with blank cell condition Try put this on empty cell :=MAX(IF(A1:A6=D2,B1:B6))then PRESS ALL TOGETHER CTRL+SHIFT+ENTER because this array formula 06-30-2021, 08:57 PM #3 Re: Max If with blank cell condition Try this:{=IF(COUNTIFS($A:$A,C1,B:B,"")>0,0, MAX(IF($A:$A=C1, $B:$B)))} 07-01-2021, 12:10 AM #4 Re: Max If with blank cell condition Try this =IF(SUMPRODUCT(1*($A$2:$A$7=C2))=SUMPRODUCT(($A$2:$A$7=C2)*($B$2:$B$7"")),AGGREGATE(14,6,$B$2:$B$7/($A$2:$A$7=C2),1),0) Pl noteArray formula should be confirmed with Ctrl+Shift+Enter keys together.If answere is satisfactory press * to add reputation. 07-01-2021, 11:15 PM #5 Registered User Re: Max If with blank cell condition Originally Posted by Phuocam Try this:{=IF(COUNTIFS($A:$A,C1,B:B,"")>0,0, MAX(IF($A:$A=C1, $B:$B)))} This was perfect!! Thank you!! Very much appreciated.