add value depending if the adjacent cell have any value

[luis6777]

Good afternoon

Im after a formula that will add a value to a cell if the adjacent cell have any date

Exemple

if cell a1 is blank cel b1 will be blank but if cell a1 isnt blank then cell b1 will be xxx

Thank for any help

[rcm]

in b1:

Please Login or Register  to view this content.

[luis6777]

Thank you, but it didnt work, i have a formula in cell a1 will this affect this formula?

[samba_ravi]

if post no2 not work
attach sample

[luis6777]

if post no2 not work
attach sample

please see attched a sample, isnt the original spreadsheet but will replicate what i need

Thanks for any help

[samba_ravi]

instead of =IF(A1<>"",xxx,"")
try
=IF(A1<>"","xxx","")

[luis6777]

this is great thanks

if i would like that the result would be equal to the value of a diferen cell instead of xxx what can i do

instead of =IF(A1<>"",xxx,"")
try
=IF(A1<>"","xxx","")

[samba_ravi]

in "XXX" ENTER THE CELL ADDRESS or select the cell
suppose in "XXX" place if you want D1 CELL VALUE
THEN
=IF(A1<>"",D1,"")

[luis6777]

tHANK YOU VERY MUCH
iN THE FIRST FORMULA IF THE CELL THAT IS REFERING TO HAVE A FORMULA THE AJACENT CELL IS GETING THE VALUE(XXX),. HOW CAN I USE THIS FORMUAL BUT IGNOR the formula, this is refering to the first formula that you give me?

in "XXX" ENTER THE CELL ADDRESS or select the cell
suppose in "XXX" place if you want D1 CELL VALUE
THEN
=IF(A1<>"",D1,"")