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