Thread: If cell a1 not blank enter 8.26 in A2 ???? How
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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


Reply With QuoteReply With Quote