Reset a cell to 0 when a conditional formula is met in another cell

  • Thread starter Thread starter Steve Cohen
  • Start date Start date
S

Steve Cohen

I don't know if this can be done or not or if it needs to be done in Visual
Basic, but I need some help.

I am looking for a formula that will reset a cell to 0 when a conditional
formula is met in another cell.

When the conditional formula in column E
"=Tradewinds_Activity>=Tradewinds_Bonus*5" is met the cell turns to white.
This part is easy and I have done already, but what I would like to add is
when the condition of column E is met it resets the values in columns D & E
to 0, so I can start counting the activity again.

The current formula in D
[SUM(SUMIF(Tradewinds!F:F,{"*Win*","*Loss*","*Push*","*Void*","*Bet*"},Trade
winds!A:A))] looks in column F of the "Tradewinds" worksheet for Win, Loss,
Push, Bet, or Void and if it finds any of them adds the amount that is in
the corresponding row of column A in the "Tradewinds" worksheet to the
Activity or column D on the "Trans_type" worksheet.

The formula in column E
[=SUM(SUMIF(Tradewinds!F:F,{"*Deposit*","*Bonus*"},Tradewinds!A:A))] is
basically the same, but looks for Deposit or Bonus in Column F of the
"Tradewinds" worksheet and the adds the amount that is in the corresponding
row of column A of the "Tradewinds" worksheet to the Rollover or column E on
the "Trans_type" worksheet.

This is kind of difficult to explain, if you need any more information, just
ask.

Thanks

Steve
 
Steve,
Please do NOT post to more than one group. All that would help read all or
most.
 
Back
Top