View Single Post
  #1   Report Post  
Eric
 
Posts: n/a
Default 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?