Discussion Formula Help in Excel
https://techcommunity.microsoft.com/t5/excel/formula-help/m-p/327739#M24781
<P>I need help with finding a formula. This is what I am trying to achieve. Let's say I type in the # '100' in A1. I would like for every time I typed 'YES' in B1 (or the B column) '12' would be added to 100. For example, 'YES' in B1 my number in A1 would become '112'. I type in 'YES' in B1 and B2 my total in A1 becomes '124'. Can I get some help with this situation? Thank you.</P>Wed, 30 Jan 2019 05:35:10 GMTChasercg2019-01-30T05:35:10ZFormula Help
https://techcommunity.microsoft.com/t5/excel/formula-help/m-p/327739#M24781
<P>I need help with finding a formula. This is what I am trying to achieve. Let's say I type in the # '100' in A1. I would like for every time I typed 'YES' in B1 (or the B column) '12' would be added to 100. For example, 'YES' in B1 my number in A1 would become '112'. I type in 'YES' in B1 and B2 my total in A1 becomes '124'. Can I get some help with this situation? Thank you.</P>Wed, 30 Jan 2019 05:35:10 GMThttps://techcommunity.microsoft.com/t5/excel/formula-help/m-p/327739#M24781Chasercg2019-01-30T05:35:10ZRe: Formula Help
https://techcommunity.microsoft.com/t5/excel/formula-help/m-p/327791#M24784
<P>I want to lock value such as 4510.83 *12=54129.96 for change my value 4935.86 instead of 4510.83</P><P>so I want to lock 4510.83 & put 4935.86</P><P> </P>Wed, 30 Jan 2019 08:20:20 GMThttps://techcommunity.microsoft.com/t5/excel/formula-help/m-p/327791#M24784BDHalderSa2019-01-30T08:20:20ZRe: Formula Help
https://techcommunity.microsoft.com/t5/excel/formula-help/m-p/327809#M24785
<P>Instead of number you may use formula in A1 like</P>
<PRE>=100+COUNTIF(B:B, "Yes")*12</PRE>
<P> </P>Wed, 30 Jan 2019 08:59:34 GMThttps://techcommunity.microsoft.com/t5/excel/formula-help/m-p/327809#M24785Sergei Baklan2019-01-30T08:59:34Z