Auto Fill fomulas

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

On 1 mei, 14:11, Jacob Skaria <JacobSka...@discussions.microsoft.com>
wrote:
> 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 init then
> > F9 should be "Y" and if not then it should be "N".- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -

Or try this for F9:

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

HTH,

WouterHM

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto fill form where reports auto fill for selection	Faron - GMail	Microsoft Access Forms	1	16th Jun 2008 07:48 AM
auto fill to fill in name when sending name required email also	deek	Microsoft Outlook Discussion	1	18th Apr 2008 04:20 AM
some excel fomulas don't update, even if I hit F9, auto calc = on	=?Utf-8?B?QkpHMjAwNQ==?=	Microsoft Excel Misc	2	17th Jul 2006 05:51 PM
using auto fill edit or fill handel	=?Utf-8?B?ZmlsbCBoYW5kbGUgb3IgYXV0byBmaWxs?=	Microsoft Excel Worksheet Functions	0	10th Feb 2006 07:01 PM
what is the difference between auto fill and custom fill	yathin	Microsoft Excel Misc	1	29th Sep 2003 12:34 PM