If one cell contains text, return value of another cell, if no - do nothing

[Slenderwoman]

Hello,

I'm looking for a "1" in A and want return value from C-1 in B.

If statement does not work for me, because
=IF(A2=1;C1;"")
changes previous row height noticeably, when the A2=/=1.

How maintain former row height?

 

[ttray33y]

Hello,

I'm looking for a "1" in A and want return value from C-1 in B.

If statement does not work for me, because
=IF(A2=1;C1;"")
changes previous row height noticeably, when the A2=/=1.

How maintain former row height?

change ; to a comma.

=IF(A1=1,C1,"")

 

[Slenderwoman]

Thanks for the reply, but when running localized Excel, for example the Polish version, it changes not only the language but also the usage of ; as you would use the comma (this is because in Polish comma is used as the delimiter for fractions).

But besides that, it doesn't answer the question further in my post; IF works fine, I just want to keep my previously set row height if the condition is not satisfied. Is there a way to "lock" row height? Or should I use VBA

 

[steve the fish]

Try manually altering row height and see if it stops the problem.