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

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

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

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

=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