View Single Post
  #2   Report Post  
 
Posts: n/a
Default

hi,
try this format
=if(and(a1="",a2=""),"not enough data",A1+A2)

-----Original Message-----
I'm trying to use an and statment in an if formula to

only run a
formula if both cells have data in them. For simplicity

lets use:

if(a1="" and a2="","Not enough data",a1+a2)

Any ideas?
.