Formula Help

Occasional Visitor

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.

2 Replies

I want to lock value  such as 4510.83 *12=54129.96 for change my value 4935.86 instead of 4510.83

so I want to lock 4510.83 & put 4935.86


Instead of number you may use formula in A1 like

=100+COUNTIF(B:B, "Yes")*12


Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies