Restrict spill result from if formula in 365

[mehidy1437]

hi,

I'm getting spill results on multiple columns from the below formula.

=IF(R2:V2>0,"",O2)

but I don't want spill results, I want results in a single column.

This gave me a #value error.

=IF(@R2:V2>0,"",O2)

How can I sort it out?

 

[Fluff]

What exactly are you trying to do?

 

[JEC]

What result do you expect?

 

[mehidy1437]

Hi @Fluff & @JEC I Just want the result in column W, no need result in X, Y, Z & AA column.

X-AA should be blank as a general cell.

 

[JEC]

Put a MAX before your IF

 

[Fluff]

I realise that, but what exactly are you trying to do with the formula?

 

[mehidy1437]

@JEC sorry, it's not giving me the correct result.

@Fluff if range r2:v2 is having a value greater than 0, then w2 should be blank otherwise w2 will have the value of cell o2. That's what I want.

 

[Fluff]

That tells us nothing, Are you trying to find if any cell in the range is > 0, all of them are >0, the sum of them is >0, or something else?

 

[mehidy1437]

That tells us nothing, Are you trying to find if any cell in the range is > 0, all of them are >0, the sum of them is >0, or something else?

I am trying to find if any cell in the range is >0

 

[Fluff]

In that case you can use Max, as suggested by JEC