how to auto populate cell on row

[eugz]

Hi All.
I have a spreadsheet where columns A and C have some values. But in column B I need manually populate by the same value, for instance, characters BB. Is it possible to auto populate column B if column A and C is not empty?

Thanks

[sandy666]

Hi All.
I have a spreadsheet

but we don't
read big yellow banner at the top of this site

[eugz]

Hi sandy666. Thanks for reply.
I attached sample spreadsheet.AutoPopl.xlsx

[sandy666]

try

=IF(AND(A1<>"",C1<>""),"BB","")

and drag down

[eugz]

Hi sandy666
Unfortunately formula doesn't work.

[sandy666]

check this

[sandy666]

if you want the formula to copy automatically to the next row, you have to change range to Excel Table (ctrl+T)