Forum Discussion

devont's avatar
devont
Copper Contributor
Jan 23, 2020

Formula Spilling Over

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 

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 23, 2020

    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(...)

     

    • devont's avatar
      devont
      Copper Contributor
      Jan 23, 2020

      SergeiBaklan 

      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. 

Resources