If cell a1 not blank enter 8.26 in A2 ???? How
 

Hi all again,

If cell A1 is not blank I need to enter 8.26 in A2

A1 A2 is not blank enter 8.26
12.5.07 8.26


A1 A2 is blank enter nothing

If cell a1 not blank enter 8.26 in A2 ???? How
 

pano, try this in A2,

=IF(A1<"",8.26,"")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"pano" wrote in message
ups.com...
Hi all again,

If cell A1 is not blank I need to enter 8.26 in A2

A1 A2 is not blank enter 8.26
12.5.07 8.26


A1 A2 is blank enter nothing

If cell a1 not blank enter 8.26 in A2 ???? How
 

On Feb 11, 12:44 pm, "pano" wrote:
Hi all again,

If cell A1 is not blank I need to enter 8.26 in A2

A1 A2 is not blank enter 8.26
12.5.07 8.26

A1 A2 is blank enter nothing

After a bit of mucking around I got it

=IF(ISNUMBER(A14),"8.26","")

But now I need it to check E14 and if the word ADO or public holiday
is there to leave it blank as well.... hmmm

If cell a1 not blank enter 8.26 in A2 ???? How
 

=IF(A1<"",8.26,"")


"pano" wrote:

Hi all again,

If cell A1 is not blank I need to enter 8.26 in A2

A1 A2 is not blank enter 8.26
12.5.07 8.26


A1 A2 is blank enter nothing

If cell a1 not blank enter 8.26 in A2 ???? How
 

Chip Pearson has a lot of info on determining holidays at his site that may
be of help to you:
http://www.cpearson.com/excel/holidays.htm


"pano" wrote:

On Feb 11, 12:44 pm, "pano" wrote:
Hi all again,

If cell A1 is not blank I need to enter 8.26 in A2

A1 A2 is not blank enter 8.26
12.5.07 8.26

A1 A2 is blank enter nothing

After a bit of mucking around I got it

=IF(ISNUMBER(A14),"8.26","")

But now I need it to check E14 and if the word ADO or public holiday
is there to leave it blank as well.... hmmm