Auto populate a column when other column is filled

[Aashna]

Hello there,

I am trying to auto populate column B with number '1000' when column E is filled with data, for which I am using formula =IF(E2="","","1000") But this is not giving me the result I wanted.

You help in this will be greatly appreciated.

Thanks,
Aashna

 

[hetfieldkaloo]

Does this work:?

=IF(E2<>"",1000,"")

 

[Aashna]

It worked!!

Thank you so much..
Appreciated!


Aashna