if empty then * based on two columns cells

[farrukh]

Hello All,

I have excel file contain 2 columns A,B. I need a formula if both cells are empty then empty . if column B cells are empty then *
If column B cells has a data so value would be of column B ??


How it would be.


Thanks

[Fotis1991]

Hi

Maybe.

=IF(AND(A1="",B1=""),"",IF(B1="",*,B1))