Needing to know how to use a "and" in a formula....
 

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?

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?
.