Autocalculating of the cell "address" doesn't work with complicated formulas

Autocalculating of the cell "address" doesn't work with complicated formulas

Dear Zoho Sheet Team,

I have a (simple) forumula:
=IF(C5="*";CONCATENATE('from ';b5+2.5);b5+2.5)

It works fine. But when i try to "pull" it by mouse to the end of the column it isn't being autocalculated/autoupdated.
So it always the same, but must be something like:
=IF(C6="*";CONCATENATE('from ';b6+2.5);b6+2.5)
=IF(C7="*";CONCATENATE('from ';b7+2.5);b7+2.5)
etc.


Thank you.