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

[pano]

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

 

[Paul B]

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]

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

 

[Guest]

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

 

[Guest]

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