Formula Help

Question

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&nbsp;B column)&nbsp;'12' would be added to 100.&nbsp;For example,&nbsp;'YES' in&nbsp;B1 my&nbsp;number in&nbsp;A1 would become&nbsp;'112'. I type in 'YES' in B1 and B2 my total in&nbsp;A1 becomes&nbsp;'124'. Can I get some&nbsp;help with this situation? Thank you.

bdhaldersa · Answer

I want to lock value&nbsp; such as 4510.83 *12=54129.96 for change my value 4935.86 instead of 4510.83so I want to lock 4510.83 &amp; put 4935.86&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

sergeibaklan · Answer

Instead of number you may use formula in A1 like
=100+COUNTIF(B:B, "Yes")*12
&nbsp;

Forum Discussion

Formula Help

2 Replies