View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default 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