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?

 

[mehidy1437]

Max is not giving any blank cells.
Instead, I have used sum of the range inside the if statement, which gave me the required result.
Your post #8, give me the right direction. Thank you.
=IF(SUM(R3:V3)>0,"",O3)

 

[Fluff]

Glad you sorted it & thanks for the feedback.