Formula Spilling Over

[devont]

Hello, 

I've encountered an issue when entering formula into a cell that I haven't encountered before. After entering the formula it spills over into the following cells and I'm not sure how to fix this. I've tried formatting the cells I don't want to spill over but that doesn't help and only complicates matters. How would I go about fixing this problem. Thank you in advance? 

Devon 

[#2]

@devont 

Better to change the formula forcing it to return scalar value, not an array. Not optimal way, but you may try to place @ in from of it

=IF(...)

to

=@IF(...)

[#3]

@Sergei Baklan 

I tried adding the @ in front and that actually helped and now I don't get that issue. Thank you very much for your help.