Try this in F9

=IF(E9="","N","Y")

If this post helps click Yes
---------------
Jacob Skaria


"starvingelectric" wrote:

I need to know if there is a formula that will automatically fill a cell if
there is data present in another cell. Example if E9 has a number in it then
F9 should be "Y" and if not then it should be "N".