Auto Fill fomulas

[starvingelectric]

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".

 

[Jacob Skaria]

Try this in F9

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

If this post helps click Yes

 

[Wouter HM]

Try this in F9

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

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





- Tekst uit oorspronkelijk bericht weergeven -

Or try this for F9:

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

HTH,

WouterHM