MAKE ALL VALUES IN THE ROW ZERO IF A CONDITION IS SATISFIED

[Shahas]

Hi All,

Need a small help.

In the data, say i have columns A-H and rows 1-8.

If, say, value in F6 < 1000, then all the data in row 6 need to be changed to 0.

Thanks in advance

[DataNath · Accepted solution]

Hey @Shahas, you could handle this with a Multi-Field Formula like so. If you want to do this based on the value of a different cell then you just need to change where I have [F] = and [RecordID] = 6 to be your column and row of interest:

F6 = 1001, no change:

F6 = 500, whole of row 6 made 0:

Hope this helps!

[Shahas]

Thanks @DataNath . It worked.