if formula to change values to zero

Hi Team,

I am looking to convert the rows that are highlighted to zero could i pls ask if you have any suggestions?

Thanks in adv!

Datasets

Accepted answers

Here is how you can do it.

Workflow:

Hope this helps : )

You didn't provide enough information. What should the logic be based on? Row number, Name, Value?

By "convert.... to zero", I'm guessing you mean the Value field?

If you were doing it manually, what logic would you use to not update the Value for the first 3 rows?

@ChrisTX the logic would be based on the name column I have tried if logics with AND or IN and none of these work.

I don't think anyone can help you, because you have not provided the basic criteria that should be used to identify the rows that should be updated.

If you were doing it manually, what logic would you use?