Discussion New Formula in Excel
https://techcommunity.microsoft.com/t5/excel/new-formula/m-p/3509589#M150623
<P>I need a new formula but i don't know how to do it. I'll illustrate the condition with an example.</P><P> </P><P>I have value in all 170 cells, then i give another value in another cell below it, be the value 68159 in cells <STRONG>E189</STRONG>. So now i want a formula which can tell me if adding any two/three of 170 cells will equal to the value of cell <STRONG>E189.</STRONG></P>Wed, 15 Jun 2022 10:41:16 GMTAdvanceacount2022-06-15T10:41:16ZNew Formula
https://techcommunity.microsoft.com/t5/excel/new-formula/m-p/3509589#M150623
<P>I need a new formula but i don't know how to do it. I'll illustrate the condition with an example.</P><P> </P><P>I have value in all 170 cells, then i give another value in another cell below it, be the value 68159 in cells <STRONG>E189</STRONG>. So now i want a formula which can tell me if adding any two/three of 170 cells will equal to the value of cell <STRONG>E189.</STRONG></P>Wed, 15 Jun 2022 10:41:16 GMThttps://techcommunity.microsoft.com/t5/excel/new-formula/m-p/3509589#M150623Advanceacount2022-06-15T10:41:16ZRe: New Formula
https://techcommunity.microsoft.com/t5/excel/new-formula/m-p/3510061#M150631
Here is a formula (assuming you have Excel 365) that you can try:<BR />=LET(in,A1:A170,target,B1,diff1,target-in,double,MAX(IFERROR(MATCH(in,diff1,0),0)),diff2,diff1-in,IF(double,double,MAX(IFERROR(MATCH(in,diff2,0),0))))<BR />Change the "in" from A1:A170 to the range of inputs and the "target" from B1 to your target value (is that E189?). The output will be 0 if not found or a number indicating one of the values in the doublet or triplet that was found. NOTE: it CAN use the same value multiple times so if the target is 20 and you have the numbers 10,11,12,13 it will find 10 because 10+10 is 20.Wed, 15 Jun 2022 12:41:53 GMThttps://techcommunity.microsoft.com/t5/excel/new-formula/m-p/3510061#M150631mtarler2022-06-15T12:41:53Z